AD 2011-18-19
Registered aircraft · 134
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:2011-18-19')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-18-19')
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:2011-18-19') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-18-19') 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.
N591ERDiamond Aircraft Sales U S A Inc · London OntarioNon-citizen corporation, flight hours not reportedN593EREwers Mary E · Santa Fe, NMN594ERFive Star Marketing Inc · Raleigh, NCN617DCDiamondxprs LLC · Fresno, CAN61EPWingsleasing LLC · Wichita, KSN620RDNorthrop Grumman Systems Corp · El Segundo, CAN621ZCSummit Aviation Inc · Belgrade, MTN63GHDiatus LLC · Sebastopol, CAN687MLJettech Consulting LLC · Houston, TXN689ERDiamond Aircraft Sales USA Inc · London OntarioN694EREmbry Riddle Aeronautical University Inc · Prescott, AZN695ERDiamond Aircraft Sales U S A Inc · London OntarioN712MMBuzzfamilyair LLC · Spring, TXN725SANaples Air Center Inc · Naples, FLN729PAK2 Aviation LLC · Greenwood Village, CON72EPEsb Group Inc · Springville, ALN730PCDs Altitude Alliance LLC · Eastpoint, FLN737AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN738LAElizabeth City State University · Elizabeth City, NCN767AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN787AMSeabreeze Mc LLC · East Islip, NYN787AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN805PAK2 Aviation LLC · Greenwood Village, CON822BREva Flight Training Academy · Mather, CAN822SAPughs Air West LLC · Carlsbad, CAN823BREva Flight Training Academy · Mather, CAN829TDAircraft Guaranty Corp Trustee · Oklahoma City, OKN833MEMc Northern Services Inc · Inlet Beach, FLN844RHPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN859LFLunken Flight Training Center LLC · Cincinnati, OHN914GMGrech Air LLC · Riverside, CAN94NGBas Part Sales LLC · Greeley, CON962SASnitka LLC · Winston Salem, NCN995DAAero Delta Alpha 995 LLC · Weddington, NC
Back to AD 2011-18-19