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.
N949RD5050 Group LLC · Valley, NEN949WBBirdwin LLC · Buras, LAN94EBFlyboyz LLC · Helena, MTN94JKWestwind Aviation Inc · Plantation, FLN94JVSlikker Benn W · Marana, AZN94KMBurton Aviation LLC · Burlington, NCN94MACox Dennis J · Beach City, TXN94MRMooney Group LLC · Washington, DCN94PBBaron 94pb LLC · Tuscaloosa, ALN94PSBrierley Michael G Trustee · Sparks, NVN94PTSmith Edward I · Suffolk, VAN94RWWithers Dana Ruth Executor · Mount Vernon, ILN94TJHuber Robert T · West Chester, PAN94WMGrowth Caddie LLC · Vero Beach, FLN94YEaa Aviation Foundation Inc · Oshkosh, WIN9502YBci Aviation LLC · Arroyo Grande, CAN950DCParmelee Charles G Trustee · Reno, NVN950PSPlane Services LLC · Twin Falls, IDN950SRAcme Aero LLC · Kingman, KSN951CDSea To Sky LLC · Diberville, MSN951POncourse LLC · Miami, FLN951PBHare Aviation LLC · Haddam, CTN951PCLeadair LLC · Brattleboro, VTN951PRPrp Aviation LLC · Ocala, FLN9527Xie Zhuopeng · Irvine, CAN9528YHunt William R · Tucson, AZN9529CSilver Lining Carpet Care & Restoration LLC · Tallahassee, FLN952CF A Phoenix LLC · Eldorado, WIN952RTOmega Management Services Inc · North Port, FLN952SVAquitaine Enterprises LLC · Saint Louis, MON9531BLash Trucking LLC · Goleta, CAN9533YN9533y Corp Trustee · Wilmington, DEN9535YSpectra Q LLC · Las Vegas, NVN9536MDsn Holdings LLC · La Crosse, WIN953ABColumbia Asset Trust Corp Trustee · Wichita, KSN953DCPhoenix Dkmc LLC · Jackson, MSN953DMMainline Services Co · Wilmington, DEN953EGCrc Aviation LLC · Laconia, NHN953MBRegistered aircraftN953MHFlywest LLC · Portland, ORN9549GMacica Stephen J DBA · Truckee, CAN954DTDatesman Miles E · Pittsburgh, PAN954PGPrime Gencore LLC · Hollywood, FLN954PWWeckbacher Paul J Jr · Inverness, FLN954TBBlue Sqy LLC · Fort Lauderdale, FLN9556ZIsland Aircraft LLC · Anchorage, AKN955CBBretthauer Erich W II · Las Vegas, NVN955GBBioventures Leasing Corporation LLC · Brookhaven, GAN955JLFlying4fun LLC · Largo, FLN955JWMike Alpha LLC · Brookfield, CT
Back to AD 2012-10-13