AD 80-01-06
Registered aircraft · 2,130
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:80-01-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-01-06')
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:80-01-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-01-06') 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.
N152GFBright Shaji · Martinez, GAN152GSBitondo Steven S · Mamaroneck, NYN152GTHansen Nelse · Lawrenceville, GAN152HFBaier Dale Edwin · Colleyville, TXN152HRWarner James A · Watertown, NYN152HWWuertz Errol Gene Jr · Mcpherson, KSN152JPatterson Casey Paul · Kinston, ALN152JLCivil Air Support LLC · Phoenix, AZN152LBurdick Rich · Montrose, CON152LEBirjandi Akbar · Westlake Village, CAN152LTMorcom Aviation Services Inc DBA · Everett, WAN152MCOkechukwu Christopher · Paramus, NJN152MFMja Flight LLC · Justin, TXN152MMWiegler Michael · Austin, TXN152NSNovember Sierra Aviation LLC · Oneill, NEN152PFTfa Holding Corp · Daytona Beach, FLNon-citizen corporation, flight hours not reportedN152PRSantaella Guillermo R · Huntley, ILN152PTWiger Theodore L · Falcon Heights, MNN152RAIndiana State University · Terre Haute, INN152REWings Over Texas Holdings LLC · Denton, TXN152SJBonus Kurt W · Wind Lake, WIN152SKCade Matt C · Canton, TXN152SLAvtech Group LLC · Saint Augustine, FLN152SPFogelberg Scot · Stillwater, MNN152SQSpartan Education LLC · Tulsa, OKN152STMckenney Vernon L · Rodeo, CAFirst renewal noticeN152TRWings Over Texas Holdings LLC · Denton, TXN152UCSkylink Xpress Inc · San Bernardino, CAN152UFWest Valley Flying Club · Palo Alto, CAN152WBing Kenneth · Millersport, OHN152WAAces High Aviatio LLC · Long Beach, CAN152WHBecker Steven Hollyfield · New Meadows, IDN152XTDiaz Alcides L · Archbald, PAN153MTMiller Nathan · Irwin, OHN153SKWings Over Texas Holdings LLC · Denton, TXN154JBLevingston Brendan W · Denali Park, AKN154SKReign Aviation LLC · Fresno, CAN155SKPea-Wayman Flight LLC · Daytona Beach, FLN156SKBrenny Christopher D · Burlington, WIN157NHRegistered aircraftN157SKGriffith Aviation Inc · Griffith, INN159SKSeacrest Enterprises LLC · Asheville, NCN159TCShooting Star Museum · Devine, TXN15NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN162FKrueger Luke T · Anchorage, AKN162PTAero Fliers LLC · Kalispell, MTN169ECFirst Eclipse Limited · Richmond, VAN16EDSimply Living LLC · Fort Myers, FLN16EFAnything Aviation LLC · Fort Lauderdale, FLN16RRAustin Donald E · Ripley, MS
Back to AD 80-01-06