Registered aircraft · 25,370

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

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:80-25-07-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:80-25-07-R1') ORDER BY n_number

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N4428RCantrell Boyd T III · Ocala, FLBuilt 1979 · S/N 18201029 N4429ETwo Niner LLC · Portola Valley, CAS/N 21064709 N4429LShingebiss LLC · Independence, ORBuilt 1982 · S/N 21064647 N4429QDyberg Mike DBA · Mount Vernon, WABuilt 1973 · S/N 17261708 N4429RMacoupin Flyers Inc · Hettick, ILBuilt 1974 · S/N 17263174 N442HBAirborne LLC · Wilmington, DEBuilt 1975 · S/N 17265246 N442MLOrlowski Micheal A · Gold Hill, NCBuilt 1966 · S/N 978 N4430RDunder Neil DBA · Cicero, INBuilt 1974 · S/N 17263175 N4431QGraham Huber L · Gulf Breeze, FLBuilt 1973 · S/N 17261710 N4431RRaritan Valley Flying School · Princeton, NJBuilt 1974 · S/N 17263176 N4432EMeyer Reed J · Moses Lake, WABuilt 1978 · S/N 38-78A0599 N4432RBend Aircraft Mechanics LLC · Bend, ORBuilt 1974 · S/N 17263177 N4433QTwo Dog Enterprises Inc · Madison, WIBuilt 1973 · S/N 17261712 N4434QFaires Kelly C · Cedartown, GABuilt 1973 · S/N 17261713 N4434RAll American Aviation LLC · Fort Worth, TXBuilt 1974 · S/N 17263179 N4435HEmtee Air LLC · Kalispell, MTBuilt 1978 · S/N 24-0731 N4436QVan Hoomissen Thomas J · Anchorage, AKS/N 17261715 N4436RDoran Kenneth J · Twisp, WABuilt 1974 · S/N 17263181 N4437HSander Elliot G · Guilford, CTS/N 24-0732 N443ACSp Sun LLC · Half Moon Bay, CABuilt 2000 · S/N 442-2000 N443ERivenbark Michael Keith · Clinton, NCS/N 102 N443RLGuinn Timothy J · Jennings, LABuilt 1996 · S/N 1223-96 N4441QHaring Clay DBA · Lincoln, KSBuilt 1971 · S/N 18800841 N4441RAtwood Flying Club · Atwood, KSBuilt 1974 · S/N 17263184 N4443HMalik Arif S · Frisco, TXBuilt 1979 · S/N 24-0779 N4446RSiler Jerry L · Eau Claire, WIBuilt 1974 · S/N 17263188 N44475Jerryair Ltd · Kent, OHS/N P21000408 N4447EFucito Daniel Ross · Lexington Park, MDS/N 38-78A0609 N4447QWolter Dennis R · Cincinnati, OHBuilt 1973 · S/N 17261719 N4447RManos Con Alas Ministries · Sierra Madre, CABuilt 1978 · S/N R18200601 N4448HNorthwest Iowa Flyers LLC · Everly, IABuilt 1978 · S/N 24-0736 N4449RMorrow David · Maynardville, TNBuilt 1978 · S/N R18200602 N444APSmith Robert S · Orlando, FLBuilt 1975 · S/N 177RG0787 N444AWHangar 22 LLC · Wilmington, DEBuilt 1995 · S/N 373-95 N444BHEbert Joel E · Peru, INBuilt 1979 · S/N 24-0864 N444BLTri Air LLC · Monette, ARBuilt 1966 · S/N 99 N444DJSims George W III · Eclectic, ALBuilt 1970 · S/N 700075 N444DSLatitude Air Inc · Port Orange, FLBuilt 1975 · S/N 22-1221 N444EEVaughn Stewart C · West Jordan, UTBuilt 1974 · S/N 17263906 N444FLAeroflyin Corp · Miramar, FLS/N 17268861 N444JGGrimmonpre Mark D · Fort Walton Beach, FLBuilt 1968 · S/N 17257013 N444JJEnviro Aviation LLC · Fort Lauderdale, FLBuilt 1993 · S/N 24-3301 N444KRSmith Wylie J · Hawthorne, FLS/N 690068 N444NXAce Aviation LLC · Mankato, MNBuilt 2000 · S/N 419-2000 N444PFRegistered aircraftBuilt 1979 · S/N 543-79 N444PPCoyne Greg · Hondo, TXBuilt 1969 · S/N 17258278 N444RWBackus Gary Carl · Chesapeake, VABuilt 1979 · S/N 21063465 N444TJWerner Michael H · Edmond, OKBuilt 1979 · S/N 17272953 N4452HMick Hill Enterprises · Cedarpines Park, CABuilt 1978 · S/N 24-0738 N4452RZitting Fredrick J · Colorado City, AZS/N 17263194

Back to AD 80-25-07 R1