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.
N28053Cae Aviation Academy Phoenix LLC · Mesa, AZN2805RMurphy Tyson L · Greensboro, NCN28065Cae Aviation Academy Phoenix LLC · Mesa, AZN28069Cae Aviation Academy Phoenix LLC · Mesa, AZN2806MCondor Aero Club Inc · Zelienople, PAN2806TN2806t Leasing Company LLC · Mason, MIN28079Abadir Peter · South River, NJN2807RHayzan Aviation LLC · Wilmington, DEN2807TSale Reported · Broxton, GASale reported, canceledN28086Cae Aviation Academy Phoenix LLC · Mesa, AZN28088Cae Aviation Academy Phoenix LLC · Mesa, AZN2808WParker David G · Sedona, AZN2809Piper Aircraft Inc · Vero Beach, FLN28090Cae Aviation Academy Phoenix LLC · Mesa, AZN28095Cae Oxford Aviation Academy Phoenix Inc · Mesa, AZN28096Cae Aviation Academy Phoenix LLC · Mesa, AZN28098Cae Aviation Academy Phoenix LLC · Mesa, AZN2809ENorth Marin Air LLC · Petaluma, CAN280AL2e2 Corporation · Menlo Park, CAN280AGWings Over Texas Holdings LLC · Denton, TXN280ASBravo Aviation Club LLC · Cary, NCN280CSYolo Farms LLC · Raleigh, MSN280DABouffard Marcel · Flowery Branch, GAN280ERNew Course Aviation Co · Golden, CON280FGFox Leasing Group LLC · Hollywood, FLN280FSAirflight LLC · Wilmington, DEFirst renewal noticeN280GACavanaugh Flying Service Inc · Minden, NEN280HGGeorgia Aviation Authority · Eastman, GAN280HRMussen Gary L · Exeter, CAN280JAFlying Tigers Flight School Ltd · Houston, TXN280JBS & S Properties Inc · N Kansas City, MON280JSStefanini Joseph M · Akron, OHN280KCMccarty Anthony O · Saint Augustine, FLN280KTGetchell Investments LLC · Dallas, TXN280LASeipp Stephen C · Laurel, DEN280MMrr Spraying LLC · Shelby, MTFirst renewal noticeN280MAMcgarity Daniel Scott · Essex, MON280MBWeber Donald E · St David, AZN280MHGulf Coast Helicopters Inc · Pearland, TXN280MLLundy Michael · Stephenville, TXN280NARohner Harlan G · Willmar, MNN280PEBravo Leasing LLC · Daytona Beach, FLN280SASouthern Aircraft Consultancy Inc Trustee · Casper, WYN280SHRottor Aviation LLC · Jasper, INN280SMAirpark Aviation LLC · Manchester, NHN280SUOhio State University · Columbus, OHN280UOhio University · Athens, OHN280WLWalloon Air LLC · Oakwood, OHN28103Hawksyntketics LLC · Jacksonville, FLN2810TBoudreau Robert D · Rusk, TX
Back to AD 2006-10-21