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.
N712MSNational Aircraft Leasing · Greenville, DEN712TCTeasdale Gregg N · Genesee, IDN712VAwf Aviation LLC · Calera, OKN712VTMiddle Fork Aviation Inc · Challis, IDN71300Finch Merry B · Marysville, CAN71305Fisher Vincent E · Burrton, KSN71317Abbatiello Vincent Jr · Cape Coral, FLN7131ETravis Michael James · Burns, ORN7131SMaya Aircraft Holdings LLC · Lee, NHN71320Wptd Inc · Munster, INN71321Boyle Christopher R · Truckee, CAN71323Air Legacy LLC · Chanhassen, MNN71326Lrc Aero LLC · Jacksonville, TXN71331Baird David W · Kanab, UTN71333Delaney Michael T · Edmonds, WAN71336Aviation Trust Company LLC Trustee · Oklahoma City, OKN71354Willis Enterprises · Enterprise, ORN71355Dal Tex Flyers Inc · Arlington, TXN71359Sparks Fly LLC · Mount Gilead, OHN71369Gosney James R Trustee · Silver City, NMN7136ECreel Jeffrey G · Gaylesville, ALN71374Farmers Supply Corp · Ontario, ORN71378Hanson Jared E · Missoula, MTN7137ESss Inc · Anchorage, AKN71384Neal Donald L · Fresno, CAN71386Single Engine Flyers LLC · Fredericksburg, TXN7138QArctic Aviation Leasing LLC · Anchorage, AKN71397Turner Chris · Kosse, TXN71398Koch Jon P · Menahga, MNN7139DBenjamin Ralph L · Fitchburg, WIN7139EBarnes Gary · Idaho City, IDN7139TPhilpot John Michael · Liberty, MON7139XBryk Steven L · Port Orange, FLN713ADSchuessler William · Turner, ORN713DJimmy & Steve Aviation LLC · Fredericksburg, VAN713GFFleming Geoffrey R Jr · Port Saint Lucie, FLN713JHMccauley James · Ithaca, NYN713KRegistered aircraftN713MATraining Wheels & Advanced Technologies LLC · La Salle, CON713PMWestbank Fishing LLC · New Orleans, LAN713SMJa Williams Investments LLC · Austin, TXN713TGSelway Construction Group LLC · Moscow, IDN71400Wubben Robert C · Waupaca, WIN71405Bowes John Michael · Lake City, FLN71408Emerald Darin · Springerville, AZN7140EJ W Bamford Inc · Oroville, CAN7140SRegistration Pending · Bermuda Dunes, CARegistration pendingN7140TMurray Robert S Trustee · Shingle Springs, CAN7141CLongview Iron LLC · Longview, TXN7141EBobek Janice C · Soldotna, AK
Back to AD 84-10-01 R1