AD 75-09-13
Registered aircraft · 4,787
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:75-09-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:75-09-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:75-09-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:75-09-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.
N310RGRome Aviation LLC · Lakeland, TNN310RRWateractive43 LLC · Auburn, CAN310SKAstroworld Travel LLC · Port Orange, FLN310TTTriple J Flying Inc · Wilmington, DEN310TWHowe Phillip T · Oro Valley, AZN310VGGtc Services LLC · Ocala, FLN310WDHernandez Jr Raymond Trustee · Burleson, TXN310WJAg N310wj LLC · South Salt Lake, UTN310ZFlyin' Dog Air LLC · Niceville, FLN311CASouthern Wings LLC · Shreveport, LAN311CHWings Of Eaglz LLC · Lamoni, IAN311JBJack Brain And Associates Inc · Castro Valley, CAN311JHHuaco Aviation LLC · Waco, TXN311KMDream Flight Florida LLC · Wellington, FLN3122MMiller-Jackson Co Inc · Oklahoma City, OKN312SCBarker Family Investments Management Co LLC · Tyler, TXN3131KAmazon Aero Corp · Wilmington, DEN3136XBobbett Robert Todd · West Richland, WAN313GBBurnett Gregory C · Rogersville, MON313MPAlpha Bravo Charlie 1 Corp · Houston, TXN313RWSarp Rentals LLC · Loudon, TNN313WTCinotto Robert L · Rhome, TXN3148PSky Hi Aviation LLC · Wilmington, DEN314DBrantley Hugh Lawton · Hazlehurst, GAN3151JStava Robert D · Brainard, NEN3153BSeverson James A Jr · Tualatin, ORN3156XBack Country Aviation LLC · Jupiter, FLN315MDuckwing LLC · Reno, NVN3160LKo Hee Sun · Norwood, NJN316MLJump N316ml LLC · East Berlin, PAN316RWFour States Tire & Service Inc · Cortez, CON31708Albatross Air Inc · Beaver, WVN317CAspn Aero LLC · Ostrander, OHN317TRRcs Aeronautical Inc · San Antonio, TXN3181UBig Sky Aviation LLC · Ridgeland, MSN318PPK&A Consulting Of Montana Inc · Billings, MTN318TWFlg Air Transport LLC · Miramar, FLN319CAAcree James · Euless, TXN31AWRestoration Dental · Chesterfield, MON31BXWhite Robert · Woodlawn, TNN31KDChinook Fibre LLC · Wilmington, DEN31KSPaxton Jacob · Killeen, TXN31KTSmith Kenneth L · Pomona, CAN31MDKarmy Paul Edward · Burleson, TXN31RTPapuchin LLC · Highwood, ILN3206JHopman Pablo I · Stow, MAN320ARAir Sal Leasing Inc · Fort Myers, FLN320BTThomas Lance E Trustee · Mesa, AZN320CRBas Part Sales LLC · Greeley, CON320DBBodian Aakil · Martinez, GA
Back to AD 75-09-13