AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N9213JRegistered aircraftN9213KCarver Clarence K · Lutz, FLN9213YCarty Eric · Anchorage, AKN92140Poplar Grove Airmotive Inc · Poplar Grove, ILN92141High Flight Academy LLC · Allison Park, PAN9214ATerhune Larry W · Saginaw, TXN9214FMaule N889z Inc Trustee · Wilmington, DEN9214JSale Reported · Hurdsfield, NDSale reported, pending cancellationN9214SC&L Aviation LLC · New London, WIN9214VGostomski Michael J · Yacolt, WAN9214WManning John · Oro Valley, AZN92159Buster Aviation LLC · Harveys Lake, PAN9215DToga LLC · Cumming, GAN9215JGrizzard Shawn C · Hayden, IDN9215LDipietro Ian · Westfield, MAN9215SGarner James L DBA · Pelham, ALN9215VGonzalez Cruz · North Las Vegas, NVN92161Skywarrior Flight Training Inc · Pensacola, FLN92169Welch William Ben · Danville, ILN9216DBlackbird Aviation LLC · Bedford, PAN9216HBurgess Alan P · Corona, CAN9216JSantana Alexandre C · Long Beach, CAN9216LLawrence Guy A · Bakersfield, CAN9216MLewellen Richard H · Mount Vernon, WAN9216NSligh Mark G · Cantil, CAN9216TLudwigson Joel · Inver Grove Hts, MNN9217DBischoff Danielle I · Palmer, AKN9217EGranberry Philip · Anchorage, AKN9217JWaicekauskas Joe · Raymondville, MON9217KR & R Air Inc · Wilmington, DEN9217MMullenbach Arnold D · Tucson, AZN9217PGruber Joachim R · Elizabethtown, KYFirst renewal noticeN9217TRegistered aircraftN9217WMartin Joe T Jr · Chandler, AZN9217XSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedN9218CArensmeyer Michael W · Longmont, CON9218DMaestas Jonathan M · Wright City, MON9218RFishe Flying Corp · Vero Beach, FLN9218SSurette Phillip · Vail, CON9218VTerrell Aviation Inc · Terrell, TXN9218WRitcheson Mark F · Tucson, AZN92194Ace Aeromotive Inc · Miami, FLN9219EStahl Randy F · Fort Benton, MTN9219HKful Flyers Foundation Inc · Fullerton, CAN9219KJones Robert M · Brooksville, FLN9219LHart Gene E · Ridgecrest, CAN9219VChen Brian K · Bakersfield, CAN921AARegistration Pending · Deland, FLRegistration pendingN921BBNorthwestern Michigan College · Traverse City, MIN921BLLewis Bertrand V · Glendale, AZ
Back to AD 81-18-04 R2