Skip to content

Registered aircraft · 25,369

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.

N64834Golden Mahalo LLC · Sheridan, WYBuilt 1982 · S/N 17275632 N6483UFalk Edward A · Seattle, WAS/N 2230 N64849Garcia Herbert A · Houston, TXBuilt 1981 · S/N 15285280 N6484AState Of Illinois · Springfield, ILBuilt 1979 · S/N 21063535 N64859Leyva Maria · New Smyrna Beach, FLBuilt 1982 · S/N 17275636 N6485HBentley Dan G · Worcester, NYBuilt 1979 · S/N 15284170 N6485QWaller Drew · Bellville, TXBuilt 1967 · S/N 680027 N64866Universal Aviators Academy Inc · El Monte, CABuilt 1982 · S/N 17275639 N6486JSpredemann Carl A · Emmett, IDBuilt 1980 · S/N 17273877 N6486LHarrison Ashley L · Danbury, CTS/N 15284414 N6486QHilhorst Kenneth E · Rocky Mount, NCBuilt 1967 · S/N 680028 N6486UDof Aviation Inc · Schertz, TXBuilt 1962 · S/N 2233 N64875Air America Flight Center LLC · Daytona Beach, FLBuilt 1982 · S/N 17275642 N6487DWayne County Airport Board · Monticello, KYBuilt 1979 · S/N 17272831 N6487QGordon Jeff · Cleveland, OHFirst renewal noticeBuilt 1967 · S/N 680029 N6487UScheifele Gay F · Derwood, MDBuilt 1962 · S/N 2234 N64882Blue Sky Flyers Inc · Greeley, COBuilt 1982 · S/N 17275643 N6488QClark Thomas L · Kingman, AZBuilt 1967 · S/N 680030 N6488UWings Leman F · Richmond, CAS/N 2235 N6488VThree Mayhoods LLC · Bonita Springs, FLS/N 172RG0725 N64891Executive Aircraft Resources LLC · Birmingham, ALBuilt 1978 · S/N 15281458 N64892Montgomery Flying Club Inc · Montgomery, ALBuilt 1982 · S/N 17275644 N64893Weitzel Laury D · Meadow, TXBuilt 1978 · S/N 15281459 N64898Fazzini Pamela A · Sedona, AZBuilt 1978 · S/N 15281464 N6489MSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1980 · S/N 15284753 N6489QMccurry Aviation Company LLC · Weatherford, TXBuilt 1967 · S/N 680031 N6489WReed Michael · Temple, TXBuilt 1981 · S/N P21000785 N64901Gwaviation Consulting LLC · Woodstock, GABuilt 1974 · S/N 17262428 N64908Fauver Russell J · Hartsville, SCBuilt 1978 · S/N 15281470 N6490DCampbell James W · Joshua, TXBuilt 1979 · S/N 17272832 N6490LAlpha Aircraft International LLC · Lake Worth, FLS/N 15284417 N6490QSuchting Carl J · Little Egg Harbor, NJS/N 680032 N64912Suburban Air Corporation · Castro Valley, CABuilt 1978 · S/N 15281473 N64915Northwoods Air LLC · Orono, MEBuilt 1982 · S/N 17275649 N64918Loeser Harold · Boca Raton, FLBuilt 1982 · S/N 17275651 N64919Hawk III Flyers Club · Republic, PABuilt 1973 · S/N 17262850 N6491UAllen Todd C · Abingdon, VABuilt 1962 · S/N 2238 N6492ELeadmon Lorren Dale Jr · Mechanicsville, MDBuilt 1978 · S/N 17272024 N6492NOrmand Philip M · Tyrone, NMBuilt 1978 · S/N 21063066 N6492YMiller Gary Lee · Pittsburgh, PABuilt 1981 · S/N 21064404 N64939Street Paul G · Anniston, ALBuilt 1978 · S/N 15281487 N6493NEagle Cap Leasing Inc · Enterprise, ORBuilt 1978 · S/N 21063067 N6493YNeed To Fly LLC · Yukon, OKBuilt 1981 · S/N 21064405 N64942Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281489 N64943Tipton Donald Jeffrey Sr · Maryville, TNBuilt 1982 · S/N 17275657 N64944Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1978 · S/N 15281490 N64949Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15281494 N6495NBusiness Trip Corp Inc · Cape Coral, FLBuilt 1978 · S/N 21063069 N6495QBaker Chad W · Forney, TXBuilt 1967 · S/N 680037 N6495UOtto David L · Lacey, WABuilt 1962 · S/N 2242

Back to AD 80-25-07 R1