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.
N324WYBig Sky Aviators LLC · Helena, MTN3251WCorporate Flight Mangement LLC · Dallas, TXN3252JBas Part Sales LLC · Greeley, CON3252REllis Eric Lee Trustee · Lincoln, CAN3254GEdling Tyrell R · The Dalles, ORN325A325a LLC · Lecanto, FLN325CDAtoco LLC · Baxley, GAN325CLRobin Motorsports And Aviation LLC · Windermere, FLN325CPRachke Aviation LLC · Gardner, ILN325DDQuick Michael D · Middletown, CAN325FGoldberg William Trustee · Telluride, CON325HLHl Ventures LLC · Los Altos, CAN325KCMount Wilson Holdings LLC · Orange, CAN325PGGuenther Enterprises LLC · Mission Viejo, CAN325PRBt Capital Assets II LLC · Saint Joseph, MON325RPN325rp Corp · Willow Spring, NCN325SHSsh Aero LLC · Saint Louis, MON325SKInternational Air Services Inc Trustee · Carson City, NVN3260FGilbert Aviation Inc · Wilmington, DEN3261CHeyman Steven · San Mateo, CAN3262XDns Aviation LLC · Fulton, CAN3269HEom LLC · Little Rock, ARN326AKN326ak LLC · Georgetown, DEN326CDOshoot Inc · Seabrook Beach, NHN326CMElemental Aviation Lc · Wichita, KSN326CPCirrus-2-Own LLC · Bellaire, TXN326DCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN326LHPhelps Michael Scott · Franktown, CON326NWLandon Aviation LLC · Loganville, GAN326SBAlpha Aviation LLC · Rancho Cordova, CAN326SRCharlie Tango Aviation LLC · Miami, FLN326TJBarnett John M · Fredericksburg, TXN326TKClark Shawn B · Fairhope, ALN3270JBerry Matthew G · Creedmoor, NCN3270RMotorman Of America Corp · Wilmington, DEN3271GPettit James P · Newport, VAN3272DTesk Aviation LLC · Steele, MON3272VWooldridge Homes LLC · New Haven, KYN3279NTips Frederick J III · San Antonio, TXN327AJAj Air LLC · Buckner, KYN327AMSchmidt Steven P · West Springfield, VAN327BFantastic Flights LLC · Exton, PAN327BPGentle Giant Holdings LLC · Onalaska, WIN327BWCessna N327bw LLC · Telluride, CON327DTLafferty Jason · Marana, AZN327EEEmpresas Marex Inc · Mayaguez, PRN327GSkysix Aircraft Management LLC · Saginaw, MIN327LKJr Flying LLC · Randleman, NCN327MWW. Morrison Consulting Group Inc · Aliso Viejo, CAN327RHInfineon Properties Of Montana LLC · Helena, MT
Back to AD 2012-10-13