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.
N24363Sale Reported · Crystal, MNSale reported, canceledN24364Monsalve Carlos M · Lewiston, NYN24373Hillsboro Aero Academy LLC · Hillsboro, ORN24385Laurel Highlands Aeronautical Academy · Latrobe, PAN24399Lcc North LLC · Freehold, NJN244004 One Air LLC · Holland, MIN24403Somboonsap Patanapong · Oakland Park, FLN24472Payne Richard L · Flint Hill, VAN24486Wilson Seth · Shafter, CAN24498Airplanes And Helicopters Of Oregon LLC · Sisters, ORN24501Dsr Cherokee 180 LLC · Dallas, TXFirst renewal noticeN24512Moran Erick A · Orange, CAN24522Wings Over Texas Holdings LLC · Denton, TXN2452UPuryear Rodney K · Pampa, TXN24530Mayfield Jon David · Dublin, TXN24532Christiansen Aviation LLC · Wilmington, DEN24544Comer Dwayne M · Glendale, AZN24546Valestin Donald P · Queen Creek, AZN24553Jensen Aviation LLC · Rancho Cucamonga, CAN24708Spartan Education LLC · Tulsa, OKN24714Bourne Randy D · Orting, WAN24725Technical Education Services Inc · Virginia Beach, VAN2472JDolev Eyal · Portland, ORN24752Training Planes LLC · Tampa, FLN24763Big South Fork Aerospace LLC · Pine Knot, KYN24764Riya Aviation LLC · Tracy, CAN24765Alpha Aircraft International LLC · Lake Worth, FLN24766Wings Over Texas Holdings LLC · Denton, TXN24767Tennessee Technology Center At Morristown · Morristown, TNN24773Grusy Norman D · Portland, ORN24775Cal Aggie Flying Farmers Inc · Davis, CAN24781Shaw Erin · Reno, NVN247LWHailey & Harmony Enterprises LLC · Las Vegas, NVN24816Graves James A Trustee · Norman, OKN24831Bishop Darin R · Livermore, CAN24856Mccreary Aviation LLC · Green Valley, AZN24857Pea-Wayman Flight LLC · Daytona Beach, FLN24874Sunrise Aviation Inc · Ormond Beach, FLN24884Bravo Victor LLC · Afton, WYFirst renewal noticeN24886Warrior II Ltd · Des Plaines, ILN24887Sunrise Aviation Inc · Ormond Beach, FLN24895Lokker Dirk E · Oakdale, CAN24908Hnatio Matthew J · South Deerfield, MAN24920Springett Justin · Boulder, CON24932Silver Express Co DBA · Miami, FLN24933Leslie Ethel M · Paonia, CON2493845u Leasing LLC · Beaver Creek, OHN24947Aty Aviation Inc · Watertown, SDN24950Erbisch Robert · Fruita, CON24981R&R Aero Services LLC · Eden Prairie, MN
Back to AD 80-01-06