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.
N702GYCirrusly LLC · Las Vegas, NVN702TCSykes Gregory P · Arlington, WAFirst renewal noticeN702VKLft Texas Aviation LLC · Austin, TXN702WStier Michael E · Chandler, AZN7037EHyannis Air Service Inc · Hyannis, MAN703DRMilligan Holdings LLC · Medford, ORN703ELN703el LLC · Sandy, UTN703LBRed Legs Aero LLC · East China, MIN703RGEfficiency LLC · Helena, MTN703SRRegistered aircraftN703TECirrus Design Corp · Knoxville, TNN703TPT & P Premier Aviation LLC · Casper, WYN704BAiron2 LLC · Austin, TXN704CTHype Holdings LLC · Denver, NCN704DRCactus Aviation LLC · Phoenix, AZN704GMLocke Stephen G · Charlotte, NCN704NEArian Air LLC · Cambridge, MAN704RBravo Fox Squared LLC · Lincoln, NEN704TEDestin Pilots LLC · Fort Walton Beach, FLN70570Miel Del Rio Grande Inc · Monte Vista, CON70595Lung Aerial Group Inc · Tustin, CAN705CMtm Investments LLC · Goshen, INN705CCPappa Mike Holdings LLC · Rayville, LAN705CDLearjetjohn Flying Club LLC · Moulton, ALN705GWFba Aviation LLC · Wildwood, FLN705SAVisser Stephen Barney · Lakewood, CON706CAHyannis Air Service Inc DBA · Hyannis, MAN706JHJgharvey Solutions LLC · Roswell, GAN706PDPlatanus LLC · Wellington, FLN706RFDeeper Shades LLC · Lafayette, LAN706TDRegistered aircraftN707AZColumbia Asset Trust Corp Trustee · Wichita, KSN707BWDrago Air LLC · Mulberry, INN707DKSunshine Peak LLC · Saint Louis, MON707EBErnst Aviation LLC · Spring House, PAN707GGLiberty Flight LLC · Goshen, NYN707JKLiquid Dreams LLC · Wake Forest, NCN707KWWaters Aero Marine Inc · South Thomaston, MEN707LAStowers Machinery Corp · Knoxville, TNN707LHN707lh LLC · Brush, CON707LJFront Row LLC · Los Alamos, NMN707LWZenith Ascent LLC · Phoenix, AZN707MMEaa Aviation Foundation Inc · Oshkosh, WIN707MPEmmet Street Holdings LLC · Saint Petersburg, FLN707PVGordon Investments LLC · Queen Creek, AZN707RLApplegate Properties LLC · Morris, ILN707SWNep Air LLC · Vineland, NJN707TDWhite Plains Enterprise LLC · Kalispell, MTN707THFly Boys LLC · Lincoln, NEN707WYBair John H · Golden, CO
Back to AD 2012-10-13