AD 2006-10-21
Registered aircraft · 44,908
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N254LWeekley Marlin G · Metamora, ILN254MAMacleod William S · Salem, NHN254MGGeorgia Aviation Authority · Eastman, GAN254MVFlight World Inc · San Juan, PRN254RNascar Aviation LLC · Silverado, CAN254RVDecamp Larry R · Clinton, INN254SFAb Prop Plane I LLC · Metairie, LAN254SHTexxon Resources Inc · Winter Park, FLN254SPAtp Aircraft 2 LLC · Wilmington, DEN254SRJets To Helis LLC DBA · Chandler, AZN254VVBoney Grady · Rhine, GAN2552WNahas Rafik E · Laguna Niguel, CAN2553MRubbert Jan D · Upham, NDN2553WBrown Jeffrey B · Punta Gorda, FLN2554WThomas Ryan · Carolina Beach, NCN2557WAndre Norman C · Downers Grove, ILN2559WHighfill Randall W · Hannibal, MON255ATThompson Aaron R · Louisville, KYN255CBZions Credit Corp · Salt Lake City, UTN255CPSierra Papa Delta LLC · Murphysboro, ILN255DHudec Darryl L · Stone Mountain, GAN255DHMarina Electric Inc · Cutler Bay, FLN255DSAircraft LLC · Battle Ground, WAN255EPEpic Aviation Inc · New Smyrna Beach, FLN255FFry Peter J · Monument, CON255GCorcoran Frank · Rochelle, ILN255JSFalcon Helicopters Inc · Logan, NMN255LCTrayer Jared T · Rollinsford, NHN255MEFalbo Michael Wayne · Sellersburg, INN255PSSamani David L · Lincoln, NEFirst renewal noticeN255SCSouth Georgia Technical College · Americus, GAN255SKParagon Airplane Leasing Co · Fort Myers, FLN255TJackson Travels LLC · Quitman, TXN255TJVolar II LLC · Edmond, OKN255WAChapman Chad E · Blakely, GAN255WFKlapmeier Alan L · Iron River, WIN255ZSmall Terry A · Vernal, UTN2560WManasseh Medical Imaging Inc · Lubbock, TXN2561WStaker Bryan P · Pleasanton, CAN2561ZMcbride Steve · Shamong, NJN2562MPacific Fleet Aviation LLC · Rochester, NYN2562UJust Plane People LLC · Irvine, CAN2563UGrande Philip M · Mt Laurel, NJN2564WReynolds Stuart N II · Church Road, VAN2565MMacair Aviation LLC · Xenia, OHN2565UVintage Flyers Inc · Napa, CAN2566UHighland Aero LLC · Mcminnville, TNN2567WSullivan Eric V · Santa Barbara, CAN2568MDe La Cruz Ronaldo · Cape Coral, FLN2568RCraven James J · Pensacola, FL
Back to AD 2006-10-21