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.
N410DRJmsat Corp · Moneta, VAN410HBJh Rfg6 LLC · Teton Village, WYN410JCFbn Holding Corp · Larkspur, CAN410JDN410jd LLC · Oneida, TNN410KGGreylady Aviation LLC · Bellville, TXN410LJBednar David · Norwalk, IAN410MPGulf Horizon Ventures LLC · Tampa, FLN410NFMurphy Aviation Inc · Gilroy, CAN410PCBohnert Matthew · Bend, ORN410PPAircraft Guaranty Corp Trustee · Oklahoma City, OKN410RHHurst Randall · Corinth, TXN410SMMartin Aviation LLC · Grandview, TXN410SRBiondich Amy · Rubicon, WIN410VVDaniels Mark A · Raleigh, NCN410WMFlying Life LLC · Middleburg, FLN4111SKnowles Warren R · Ocean City, NJN4116GAcaats LLC · Queen Creek, AZN411ABAmerican Time Machine LLC · Edmond, OKN411APN411ap LLC · Independence, KSN411BJclm Aviation LLC · Atlanta, GAN411DTSliwa Kevin Joseph · Fishers, INN411EEVaini Marc · West Plains, MON411EGCompton William C · Anchorage, AKN411EPRsbrm Aviation LLC · Lakewood, NJN411GJGuardian Jet LLC · Guilford, CTN411GTTeam 646 LLC · Jupiter, FLN411HZCedar Dix LLC · Lancaster, KYN411JGKern County Aviation Leasing LLC · Bakersfield, CAN411LGLover Girl Aviation LLC · Peachtree Corners, GAN411MARouse William J · Palm Springs, CAN411PKC C Owen Tile Co Inc · Jonesboro, GAN411RCLola Aviation LLC · Truckee, CAN411STwin Adventures LLC · Cincinnati, OHN411SAMasdon Aviation LLC · Guntersville, ALN411SESwm III Investment 1 LLC · Lubbock, TXN411SKRiverside Aviation LLC · Fernandina Beach, FLN411SRC1n Cirrus G3 LLC · Rockford, ILN411THCrash Landers LLC · Webster, NYN411TTRambod Marc · Taos Ski Valley, NMN411TXGilbert Ivory M · Bonita Springs, FLN411UMEasy Wind LLC · Nashville, TNN411VTvc Aviation Inc · Lebanon, OHN411VGMontala Investments LLC · Montgomery, ALN411VTFletcher Holdings Of Nc LLC · Winston Salem, NCN411WBRiser Aviation LLC · Covina, CAN411YPPops Adventures LLC · Highland, UTN4122PCloud Eight LLC · Los Altos, CAN4124WGeaux Automotive Advertising LLC · La Place, LAN4125GSeeding Operations And Atmospheric Research (Soar) · San Angelo, TXN412AGAme Aviation LLC · Denver, CO
Back to AD 2012-10-13