AD 75-01-07
Registered aircraft · 2,118
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-01-07')
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-01-07')
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-01-07') 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-01-07') 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.
N2080LSparks Halli · Burdett, NYN2080SRobinson Earl J · Cotuit, MAN2081WN5724v LLC · Kalispell, MTN2082WRegistered aircraftN2083LHorizon Chaser LLC · Woodway, TXN2084WBurkett James Austin III · New Port Richey, FLN2085LFly More Drive Less LLC · Hot Springs, ARN2090LBarnes Seth M · Hot Springs, ARN2092WEarthcirc08 LLC · Chagrin Falls, OHN2093WKliewer Silas M · Ulm, MTN20ACOwen Ray L · Los Gatos, CAN20RLRose Timothy A · Hickory, MSN2105LBishop William E · Fredericksburg, TXN210RMace Steven B · Ocala, FLN2113LGilbert Ben · Omaha, NEN2116LHagg Theodoor · Johnson City, TNN2117LCottage Grove LLC · Oklahoma City, OKN211EEV35a Speedsters LLC · Henderson, CON2124LMax D Watkins Pc · Tulsa, OKN2126LLuurtsema Jon A · Alto, MIN212RJBishop Mike · Rifle, CON212VGuilfoyle Robert J · Fairhope, ALN2132LCsrh Ventures LLC · Lubbock, TXN2135WLeary Kevin · Midland, TXN21398Peterson Peter M · Silverado, CAN213QHardcopf Robert W · Apple Valley, MNN214DRMarsh David · Flower Mound, TXN214QHassenger Management Strategies Inc · San Antonio, TXN214RCWhitcomb David · Morrisville, VTN215BFWiederhoeft Dustin L · Fairmont, MNN215QSooter Craig A · Sedgwick, KSN215YHodgson Mark · Fox Point, WIN217QLasc Aviation Inc · Callaway, FLN21914Autumn Air LLC · Prescott, AZN219QBoe John · Langdon, NDN21SHFlight Less LLC · Helena, MTN2201LHorizon Enterprises Vne LLC · Aurora, CON2209LOrth Duane C · San Antonio, TXN221ABFlying Banana LLC · Onsted, MIN221TLLogan Thomas D · Incline Village, NVN222CBNiki Hankins Consulting LLC · Colorado Springs, CON222DRGoodknight Gregory W · Nevada City, CAN222DTClipper Sky LLC · Las Vegas, NVN222SPresley Wilber L · Columbus, OHN222SMMacknight James G · Morgan Hill, CAN224HPNguyen Cody · Richmond, CAN224SHWhitney Bryan · Lake Havasu City, AZN2255NMalard Darren L · Bismarck, NDN225SPGross Flying Service Inc · Larned, KSN2265LNeilsen Lorenzo I · Wilmington, NC
Back to AD 75-01-07