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.
N29WHSr-22 Partners LLC · Danville, CAN29XXMustang Aeronautics LLC · Chandler, AZN2BG2fly LLC · Seattle, WAN2CKPegasus Aviation Services LLC · Jupiter, FLN2CWMiller Steven D · Mccall, IDN2FTContemporary Aviation LLC · Excelsior, MNN2HNFlyboy Aviation LLC · Pensacola, FLN2MAFlorida Air Leasing LLC · Gainesville, FLN2MLMclaury Kim · Mission Hill, SDN2REEtzler Richard D · Durango, CON2RXJbs Enterprises LLC · Hamilton, MTN2SAInternational Air Services Inc Trustee · Carson City, NVN2SLLowe Aviation LLC · Bountiful, UTN2VRRead Andrew R · Milwaukee, WIN2VVAir Mods And Repair Inc · Robbinsville, NJN2XFN2xf LLC · Windermere, FLN2ZTwo Zulu LLC · Mclean, VAN2ZHClt Thompson Holdings LLC · Charlotte, NCN3000DHungy Air LLC · Bettendorf, IAN30038Stockyard LLC · Wilmington, DEN300BDAircraft Inc · White Bear Lake, MNN300CGAircraft Guaranty Corp Trustee · Oklahoma City, OKN300HCPs Air LLC · Evansville, INN300HGHouchens Insurance Holdings Inc · Bowling Green, KYN300HMEngage Communication Inc · Aptos, CAN300KM300 Knots Inc · Henderson, NVN300NVHolombo Lee C · Trenton, KYN300SQVortex Aviation LLC · Houston, TXN300TLAlls Peyton H · Raleigh, NCN300YBGospel Ministries International Inc · Collegedale, TNN3011Hedrick Kirby L · Cora, WYN301BZPin High LLC · Ruston, LAN301CPWhy Not Fly Aviation LLC · Gainesville, VAN301EBQuesnel William G · Truckee, CAN301EFRegistered aircraftN301FBlue Sky November LLC · Mamaroneck, NYN301FCTango Charlie Aviation LLC · Thomasville, GAN301GKBrown Water Associates LLC · Monticello, FLN301HLnc4 Mcx1 LLC · Rexburg, IDN301JPAircraft Guaranty Corp Trustee · Oklahoma City, OKN301MDMoritz Davis Aviation LLC · Edina, MNN301RMSc213 LLC · Van Wert, OHN301RVK6 Construction Inc · Clovis, CAN3024HMll Air LLC · Kalispell, MTN30268Rudd Terry R · Clarkston, WAN30280Emery Clint L · Texarkana, ARN30282Saucerman Equipment Leasing LLC · Indianapolis, INFirst renewal noticeN302BCG2 Leasing LLC · Cedar Spring, MIN302BYAviation Homes LLC · Terrell, TXN302CDChadmatt Explorations LLC · Pensacola, FL
Back to AD 2012-10-13