AD 90-06-13
Registered aircraft · 1,827
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:90-06-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:90-06-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:90-06-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:90-06-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.
N560AFMegashipp Ventures II LLC · The Woodlands, TXN560AVTeton Leasing LLC · Pocatello, IDN560BCPlatform Energy Aviation LLC · Lubbock, TXN560BJBanu LLC · Las Vegas, NVN560BLKac Md LLC · Fort Mill, SCN560BMBruce Tanski Construction & Development LLC · Halfmoon, NYN560BPCitation V Partners LLC · Las Vegas, NVN560CJettech Holdings LLC · Broomfield, CON560CBAircraft Trust & Financing Corp Trustee · Wilmington, DEN560CCJet Centennial LLC · Greenwood Village, CON560CE5 Star Aviation LLC · Aurora, MON560CFMax Air Group LLC · Waterford, MIN560CJTrans Exec Air Service Inc · Van Nuys, CAN560CSPlatinum Faith LLC · Middletown, DEN560CVHw Aviation LLC · Katy, TXN560CXSpudaire LLC · Pasco, WAN560CZRosado Aviation Inc · Moosic, PAN560DLLandmark Media Enterprises LLC · Norfolk, VAN560EMEjb LLC · Ponce Inlet, FLN560EPZero Five Kilo Corporate · Jackson, WYN560FFParrott Air LLC · Florence, SCN560FPEdwards Carl E Jr Trustee · Oklahoma City, OKN560FTN560ft LLC · Middletown, DEN560FWPspb Aviation LLC · Fort Worth, TXN560GMachugh David · Pasco, WAN560GG2141 Corp · Wilmington, DEN560GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN560GTN560gt LLC · Mount Upton, NYN560HKa N22cr LLC · Lewes, DEN560HLH C E Leasing LLC · Cleveland, TNN560HMG Money LLC · Delavan, WIN560HSNice Neighbors LLC · Wilmington, NCN560JAJjl Aviation LLC · Springville, IAN560JDBig Mountain Aviation Inc · Whitefish, MTFirst renewal noticeN560JJXcancerair LLC · Omaha, NEN560JKCitation Investments LLC · Dallas, TXN560JMDodson International Parts Inc · Rantoul, KSN560JSDouble R Air LLC · Bossier City, LAN560JW3640 Aviation LLC · Mandeville, LAN560KHHarrison Aviation LLC · Salem, ORN560LFCamelot Express LLC · Roswell, GAN560LHL&H Sub LLC · Gillette, WYN560LTLife Time Inc · Chanhassen, MNN560LWLarry Aviation LLC · Richland, WAN560MFMorales J Mark Trustee · Corpus Christi, TXN560MGSongbird Aviation LLC · Nashville, TNN560MMN2617u LLC · Amarillo, TXN560MRCitation Associates Inc · New Castle, DEN560PAN560pa LLC · Wilmington, DEN560PEFortuna Travel Partners LLC · Burbank, CA
Back to AD 90-06-13