Skip to content

Registered aircraft · 25,368

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.

N98731Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276341 N98738Bas Part Sales LLC · Greeley, COBuilt 1985 · S/N 17276342 N9873BGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1982 · S/N 172RG1064 N9873QMf Aviation Inc · Reston, VABuilt 1975 · S/N 17265817 N9873TMaycock David V · Hurricane, UTBuilt 1978 · S/N 38-78A0227 N9873VChester Charter Inc · Chester, CTBuilt 1974 · S/N 17264539 N9874EBlust Henry A · Arlington, VABuilt 1979 · S/N 17272282 N9874GKorn Jeffrey J · Marietta, GABuilt 1971 · S/N 17259774 N9874QRodas Mary P · Blue Jay, CAS/N 17265818 N9874VSisler Allen R · Terra Alta, WVBuilt 1974 · S/N 17264540 N9875G1 Aircraft LLC · Kissimmee, FLBuilt 1971 · S/N 17259775 N9875MKaelin Robert A · Fayetteville, ARBuilt 1972 · S/N 17260575 N98763Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276344 N98769American Patrols Inc · Midland, TXBuilt 1985 · S/N 17276345 N9876GKentucky Lake Aviation LLC · Huntingdon, TNBuilt 1971 · S/N 17259776 N9876QRegistered aircraftBuilt 1975 · S/N 17265820 N9876VDelhotal Raymond K · West Brooklyn, ILBuilt 1974 · S/N 17264541 N98772Solberg Aviation Co Inc · Whitehouse Station, NJBuilt 1985 · S/N 17276347 N98774Simplifly LLC · Mesa, AZBuilt 1985 · S/N 17276349 N98776Melbourne Flight Training LLC · Melbourne, FLBuilt 1985 · S/N 17276350 N9877BAndra Joshua Corey · Riverton, UTBuilt 1982 · S/N 172RG1066 N9877GRowse Larry G · Plain City, OHBuilt 1971 · S/N 17259777 N9878GRoyal Aviation Academy LLC · Sarasota, FLBuilt 1971 · S/N 17259778 N9878QNesland Patricia M · Burton, WAS/N 17265822 N98792Stanzione Daniel F · Antelope, CABuilt 1985 · S/N 17276355 N98795Richmor Aviation Inc · Scotia, NYBuilt 1985 · S/N 17276357 N9879QCoker Design Group LLC · Campobello, SCS/N 17265823 N987ANf County Flying Club Inc · Chateaugay, NYBuilt 2003 · S/N 921-2003 N9880GHewlett John · Columbus, OHBuilt 1971 · S/N 17259780 N9880QAircraft Resource Center Inc · Lakeville, MNBuilt 1975 · S/N 17265824 N98811Kadena Aero Club · Apo Ap, CABuilt 1985 · S/N 17276359 N98819Oxford Flying Club Inc · Oxford, CTBuilt 1985 · S/N 17276362 N9881GFortenberry Robert N · Pascagoula, MSBuilt 1971 · S/N 17259781 N9881QSky Drivers LLC · Lavalette, WVFirst renewal noticeBuilt 1975 · S/N 17265825 N9881VShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1974 · S/N 17264544 N98824Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276363 N9883GLagor Mark D · Parshall, NDBuilt 1971 · S/N 17259783 N98843American Patrols Inc · Midland, TXBuilt 1985 · S/N 17276367 N9884GBarbour John P · Dexter, MOBuilt 1971 · S/N 17259784 N9884VShockley James F · Loves Park, ILBuilt 1974 · S/N 17264546 N9885QAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 17265829 N9885VNix Jacob DBA · Johnson, KSBuilt 1974 · S/N 17264547 N9886CAlm Ronald · Kuna, IDBuilt 1978 · S/N R18200482 N9886VBognar John W III · Sardinia, NYBuilt 1974 · S/N 17264548 N98873Laguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeBuilt 1985 · S/N 17276369 N9887CLeonard Paul A Jr · Grand Beach, MIBuilt 1978 · S/N R18200484 N9887LSkywarrior Flight Training Inc · Pensacola, FLBuilt 1986 · S/N 17276645 N9887QTupelo Aeronautics Inc · Tupelo, MSS/N 17265831 N9887VDarby Holly M · Midland, TXBuilt 1974 · S/N 17264549 N98887Jodkin Jason · Confluence, PABuilt 1985 · S/N 17276373

Back to AD 80-25-07 R1