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.
N737FTIowa Lakes Community College · Estherville, IAN737FUWarren Darryl · Clinton, ARN737FXZborowski Ronald W · Eighty Four, PAN737FYMiller Davette D · Mesa, AZN737GAN737ga LLC · Jupiter, FLN737GCDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYN737GDEfc Aviation LLC · Lancaster, KYN737GEFlying Neutrons LLC · Lebanon, OHN737GKGeneral Aviation LLC · Henderson, NVN737GLFlying Panthers Flight School Inc · Citrus Heights, CAN737GMFive Rivers Flight Training LLC · Livermore, CAN737GPWilliams Allen E · Redlands, CAN737GRRick Aviation Inc · Newport News, VAN737GSRising Wings Aviation Inc · Casper, WYN737GUWings Over Texas Holdings LLC · Denton, TXN737GVTas Aviation Of Defiance Inc · Defiance, OHN737GZSauk Valley Aviation Inc · Sterling, ILN737HBTokach David L · Sierra Vista, AZN737HELaurel Highlands Aeronautical Academy · Latrobe, PAN737HGGuyair Inc · Saint Charles, MON737HHG A W Flying Club Corp · Palos Heights, ILN737HJPersonal Aviation Inc · Poway, CAN737HMMeyer Raymond · Ukiah, CAN737HNAvey Gregory B · Saint John, INN737HPLinn Anthony B · Westborough, MAN737HUBerry William J · Troy, MIN737HVSchuler Eric C · Fort Salonga, NYN737HWCag Aircraft Holdings LLC · Crystal River, FLN737HYSeven 4 Zulu LLC · San Diego, CAN737JBemis Susan · Newhall, CAN737JHMcdermotts Letsfly LLC · Somerton, AZN737JJAvid Aviation LLC · Gilbert, AZN737JKJuliet Sierra Foxtrot LLC · Denver City, TXN737JLN737jl LLC · Dimmitt, TXN737JMMccormack June · Borrego Springs, CAN737JNSurplus Products Inc · East Point, KYN737JQPorter Timothy Charles · Bloomington, INN737JRG&M Aircraft Inc · Wheat Ridge, CON737JSBoren Aviation LLC · Knoxville, TNN737JTColman Ronin B · Arlington, TXN737JUFussell Tracy L · Mc Rae, GAN737JXR&R Aero Services LLC · Eden Prairie, MNN737JYWright Robert Gene · Kearney, MON737KCH & H Aviation Enterprises LLC · Fairfield, OHN737KDLane Chris S · Tijeras, NMN737KE247 Aviation LLC · Palm Coast, FLN737KGRamp 106 LLC · Lynn Haven, FLN737KJRed-Tailed Hawks Aviation Academy · Mukilteo, WAN737KMSmith Daryl N · Coventry, CTN737KQZuidema Herbert L Trustee · Redding, CA
Back to AD 81-18-04 R2