AD 2012-03-52
Registered aircraft · 522
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-03-52')
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-03-52')
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-03-52') 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-03-52') 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.
N755BWSky West Aviation Inc Trustee · Albuquerque, NMN767BKF&E G A Inc · Miami Springs, FLN767SBRegistered aircraftN772PACassity Scott · Las Vegas, NVN772PCThompson John Christopher · Dallas, TXN7734MHeinrich Bruce · East Burke, VTN773VAndy Petree Inc · Denver, NCN7758JLeaman Gary R · Alpine, WYN7772LJerez John J · Bonita, CAN777XMDenton Lake Ltd · Port Charlotte, FLN77GJSees Aviation Inc Trustee · CheltenhamN77PHRiddick Aviation LLC · Columbia, MON781TCKeystone Ridge LLC · Colorado Springs, CON781WBCopley Square Air LLC · Weston, MAN782JBRibaudo Janice · Los Angeles, CAN783SYKrajewski Richard · North Sutton, NHN78PEFun Aviation LLC · Rockford, MIN792RCRegistered aircraftN79333Blue Moon Navigation Inc · Austin, TXN79336Yaggie Allen · Wahpeton, NDN79339Wetzel Matthew DBA · Round Mountain, TXN795PJWarren John B · Port Jefferson, NYN79FMWoods Executive Services Inc · Mineola, TXN79SMTurbine Services And Consulting LLC · Bedford, TXN800DD2826 LLC · Inola, OKN805PMColwell Blue Berry Farm LLC · Ellsworth, MEN807PJPhillips David T · Warsaw, NCN808WMCarney Adam S · Middletown, NJN809PAHardy David · Fairview, MTN80HWSouthern Aircraft Consultancy Inc Trustee · Casper, WYN811TSManagement Programs Corp · Vero Beach, FLN812PTAngel Ventures LLC · Natchez, MSN815TLee D Trotter Do Pc · Rapid City, SDN816LMKobylar Lester J · Greensboro, GAN81FMSky West Aviation Inc Trustee · Albuquerque, NMN823AFAerosset LLC · San Juan, PRN826JSBranson Chad F · Asheboro, NCN828BPHot Wings Aviation Ltd · Wilmington, DEN82CGLincoln David C · Henderson, NVN831TAircraft Guaranty Corp Trustee · Oklahoma City, OKN83RJMckenzie Aviation Corp · Port Orange, FLN843LGPapa Mike LLC · Dover, DEN871TXNlmds Leasing LLC · Tierra Verde, FLN872PALima Delta Co Trustee · New Castle, DEN87FAAircraft Partner Holdings Inc Trustee · BerlinN888KNBaker Tim Young · Lafayette, LAN888REDill Harry H Trustee · Mebane, NCN890RDSengle Gregory R · Amherst, MAFirst renewal noticeN892PSKahoe Timothy P · Charlotte, NCN898PJBaucum Jeffrey P · Sequim, WA
Back to AD 2012-03-52