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.
N310JGMarc Inc · Bolton, MSN310JNAustin Baumgarten Inc · Tomah, WIFirst renewal noticeN310JPBrock Kyle · Riverdale, CAN310JWWharton Melissa P · Wise, VAN310KMStitt Consulting Inc · Titusville, FLN310LDAbq 421 LLC · Albuquerque, NMN310LPIsaacs W Bradford · Las Vegas, NVN310LWMy Way Aviation LLC · Weston, FLN310MAustin Security Inc · Battleboro, NCN310MGGoroff Marc · Livermore, CAN310MWKeystone Aerial Surveys Inc · Philadelphia, PAN310PPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN310PSRoe Fabricators Inc · Chester, PAN310PZCardozo Armando J · Miami Gardens, FLN310RGRome Aviation LLC · Lakeland, TNN310RRWateractive43 LLC · Auburn, CAN310SATailwind LLC · Cameron, NCN310SKAstroworld Travel LLC · Port Orange, FLN310SMRegistration Pending · Pocatello, IDRegistration pendingN310TNFarfalla Aviation LLC · Santa Rosa, CAN310TTTriple J Flying Inc · Wilmington, DEN310TWHowe Phillip T · Oro Valley, AZN310VGGtc Services LLC · Ocala, FLN310VPN310vp LLC · Galena, OHN310WDHernandez Jr Raymond Trustee · Burleson, TXN310WJAg N310wj LLC · South Salt Lake, UTN310ZFlyin' Dog Air LLC · Niceville, FLN3111DMonarch Air Services LLC · Ballwin, MON31121Full Flaps 2 LLC · Peachtree City, GAN3112KBeilman Charles C · Wallingford, CTN3112YWykoff Donald W · West Chester, OHN31143Mjj Aircraft Inc · Wilmington, DEN3114W865 Aviation LLC · Knoxville, TNN3114YN635v LLC · Nacogdoches, TXN3119TRiverwind Strategic Solutions LLC · Lewes, DEN311AVCane Associates Aviation Consultants LLC · Mount Pleasant, SCN311CECirrus Design Corp · Duluth, MNN311CFHronkin Jessie G · Palmer, AKN311CHWings Of Eaglz LLC · Lamoni, IAN311DBIts Plus Inc · Plano, TXN311FSLunsford Group Inc · Weaverville, NCN311GJ755 Aviation LLC · Lake Mary, FLN311HN311h LLC · Vineyard, UTN311JBJack Brain And Associates Inc · Castro Valley, CAN311JLPoelking Theodore J · Dayton, OHN311KMDream Flight Florida LLC · Wellington, FLN311KNViking Aircraft Leasing LLC · Bethel, MNN311LRegistered aircraftN311MWS S Euroflyer III Ltd · Wilmington, DEN311PDHaehnle Michael J · Milford, OH
Back to AD 2012-10-13