AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N70809Inman Steve J · Billings, MTN70810Wrangell Mountain Air Inc · Palmer, AKN70816Proctor Keith · Paint Lick, KYN70822Southern Seaplane Inc · Belle Chasse, LAN70826Chabay Shawna P · Greenleaf, IDN7082SBills Jack M · Naples, FLN70845Registered aircraftN70849Hedrick Chad A · Goshen, OHN7084FState Of Wisconsin · Madison, WIN7085QJust Plane Fun Et LLC · East Troy, WIN70861Importico William J · Bridgewater, NJN70867Phantom Flyer LLC · Yelm, WAN70872Johorn LLC · Downingtown, PAN70884Walbert Frank J · Pagosa Springs, CON70885Bates Ranches · Condon, ORN70888Nbw Wings LLC · Cave Creek, AZN7088QTraviss Siegfried H · Athol, IDN70892Williams Tyler D · Tracy, CAN708MTThibodeau Michael L · Joseph, ORN709Frey Robert Henry Jr · Keller, TXN70901Ckt Aviation LLC · Anchorage, AKN70902Bienz David E · Scottsdale, AZN70913Sunset Aviation LLC · New Iberia, LAN70915Patterson Thomas L · Bryan, TXN70917Edwards Guy A · Sedalia, CON70920Lannoye Tyler G · Leeds, NDN70933Beta Flight LLC · South Burlington, VTN70938Dawson Ranch Aviation LLC · Encinal, TXN70949Saucier Brock D · Dallas, TXN70956Holdsworth Randy L · Zoar, OHN70966Kelly David M · Hedgesville, WVN70967Bramblett Steve · Bennington, OKN70974Ross Donald Malcolm · Lawton, OKN70977Soran Patrick David · Reno, NVN70981Broken Rainbow Enterprises Inc · Torrey, UTN70984Rau Brian C · Medina, NDN70986Hobby John J · Durango, CON70987Sutherland Jason · Auburn, WAN70988Kelley Ronald C · Deer Lodge, MTN709CPCivil Air Patrol · Maxwell Afb, ALN709DBPowerhouse Detox Inc · Otis, ORN709RHHope Ronald F · Clemmons, NCN70CWHeartland Travel LLC · Columbia, MON70GJOzark Airworks Inc · Midway, ARN70KYSurfside Seaplane Training LLC · Lino Lakes, MNN70TCTwo Ten Bravo Delta LLC · Kaiser, MON70VHBlue Sky Flyers LLC · Fairfield, NJN70WBGraves Lucas M · Santa Rosa, CAN70WHOrtega Ricky J · Amarillo, TXN71002Sheepdog Aviation LLC · Murfreesboro, TN
Back to AD 84-10-01 R1