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.
N585GT2029 Realty Corp · Farmingdale, NYN585SRNublos Group LLC · Birmingham, ALN585SW123mm LLC · Hilton Head Island, SCN585TX22t-2360 LLC · Austin, TXN5863N5863 LLC · Kalispell, MTN5868CShimomura & Co Cpas Pc · New York, NYN586CAOrlando Holding Company LLC · Port Jervis, NYN586CFJbw Aviation LLC · Benton, KYN586SRFat Alberts Inc · Poteau, OKN586WJCirrus Design Corp · Knoxville, TNN5870MMcdonald Brian L · Van Alstyne, TXN5878MKodiak Helo LLC · Kodiak, AKN587ATBcaa Aviation LLC · Westfield, INN587CPBear Automation Inc · Fayetteville, ARN587DGLsm Aviation LLC · Rome, GAN587GFReher David P · Arlington, TXN58801Lansing Aviation LLC · Windsor, CON588ANCalifornia In Nice Inc DBA · San Jose, CAN588CAMj Paws LLC · Wilmington, DEN588CTLynn Johnny Wayne · Indian Trail, NCN588EBBuckley Aviation LLC · Swainsboro, GAN588PAirstar LLC · Lees Summit, MON588PCAustin Aviation LLC · Santa Ana, CAN588SRegistered aircraftN588SRSojo Air LLC · Abilene, TXN589CTNorton Vickie R · Huntington Beach, CAN589MPMichael Nehring Inc · Mohall, NDN589PUniversity Of Central Missouri · Warrensburg, MON589RBDukas Air LLC · Fort Lauderdale, FLN589RCSkyflite LLC · Hillsboro, ORN589SFWings Sunward LLC · Port Orange, FLN589SRBe Happy LLC · Nashua, NHN58ACAlto Cirrus LLC · Coral Gables, FLN58ARAnnis Aviation LLC · Gray, GAN58BPN7ss LLC · Nashville, TNN58BRButler Investments LLC · Baldwyn, MSN58CJWischer Enterprises LLC · Grandin, NDN58DAUniversity Of Central Missouri · Warrensburg, MON58DBTennis Associates Inc DBA · Erie, CON58DFB727 LLC · Midland, TXN58DJPtc Financial Inc · Wilmington, DEFirst renewal noticeN58GFCollier Air LLC · Fernandina Beach, FLN58GPPmg Capital Holdings LLC · Mesa, AZN58HBjk Aviation LLC · Morgantown, WVN58HDRoberts John E · Naples, FLN58JASunergy Solutions LLC · Londonderry, NHN58JDGrossman Kenneth R · Merced, CAN58JMLucky 7 Operating LLC · Many, LAN58KTBarron Equipment Leasing LLC · Port Washington, NYN58LGMorgan Farms LLC · Twin Falls, ID
Back to AD 2012-10-13