AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N761WQTower Aircraft Associates Inc · Ventura, CAN761WTCv Aviation LLC · Logan, UTN761XEGordon Bruce S Trustee · Aspen, CON761XFRapa Dennis H · North Dartmouth, MAN761XGMedusa Inc · Lexington, VAN761XYAshby Scott J · Lemoore, CAN761XZKrabill Enterprises LLC · Christmas Valley, ORN761YDAero Clean Technologies LLC · Lynchburg, VAN761YGGoody Birds LLC · Prattville, ALN761YHArnett Family Inc · Mesa, AZN761YKFanning Fred W · Fairlawn, OHN761YMSkyberry Jam Aviation LLC · Coppell, TXN761YSThompson Gary P · Mammoth Lakes, CAN761YWWalker Gilbert C · Camerillo, CAN761ZBIts Academic Inc · Elyria, OHN761ZEBrandvik Pipe & Equipment Inc · Borger, TXN762ARMuller Consulting LLC · Leesburg, VAN762CRRadio Net Corp · Camarillo, CAN762ESEs LLC · Tulsa, OKN762HRAtlantic Outdoor Products LLC · Daniel Island, SCN762SRHenri Duval Ltd LLC · Wilmington, DEN762TCCirrus Holdings LLC · Jordan, MNN7632QPremier Helicopters LLC · Carson City, NVN763CPlane Partners LLC · Greensboro, NCN763CDFlyingmalbec LLC · Lakeway, TXN763EAHyannis Air Service Inc · Hyannis, MAN763LSJaybird Aviation LLC · Many, LAN763PKBy-The-Way LLC · Burlington, VTN76498Doucey Mark R · The Villages, FLN764DGPayette Sr22t LLC · North Salt Lake, UTN764EAHyannis Air Service Inc · Hyannis, MAN764PBBisono Pablo R · Guaynabo, PRN764SAerotrans Management LLC · Mercer Island, WAN764WPOgre Air LLC · Seattle, WAN765CFCs Air LLC · Osage Beach, MON765CTBim Jett LLC · Sacramento, CAN765FLAviation Angel Tours LLC · Beverly Hills, CAN765GMFacts Holdings Inc · Clearwater, FLN765GPFlatiron Properties LLC · Wildwood, MON765JBN765jb LLC · Colorado Springs, CON765LTDrj Aviation LLC · Dover, DEN765SVTop Gun Aviation LLC · Gilbert, AZN766ATAdvisoar LLC · Jacksonville, FLN766DBWhelan And Associates Pllc · Eagle, CON766DCMike Tango LLC · Kalispell, MTN766SBAirhawk2 LLC · Cannon Beach, ORN766WTMontana Sky Aviation LLC · Kalispell, MTN76747Walter Timothy Andrew · San Rafael, CAN7676KSunflow Holdings LLC · Truckee, CAN7677DSteel Aviation Inc · Phillipsburg, OH
Back to AD 2012-10-13