Skip to content

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.

N191WWLichtscheidl Ted J · Forest Lake, MNBuilt 1972 · S/N 17260840 N1920CVanjara Gufran U · San Ramon, CABuilt 1964 · S/N 2686 N1920FChristensen Dean G · Elk Grove, CABuilt 1979 · S/N 17273012 N1921FState Of Iowa · Iowa City, IABuilt 1979 · S/N 17273013 N1922QLendor Jason C · Chicago, ILBuilt 1972 · S/N 177RG0322 N1922VRogers Randall J · Newalla, OKBuilt 1974 · S/N 17263796 N19234Sharkey William Patrick · Walla Walla, WABuilt 1976 · S/N 17702563 N1923FAtlanta Air Academy LLC · Kennesaw, GABuilt 1980 · S/N 17273015 N1923QHansen Eric P Trustee · Arlington, WABuilt 1973 · S/N 177RG0323 N1923RUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 1217-2024 N19245Immel Justin Harrison · Minonk, ILBuilt 1976 · S/N 17702564 N1925QReagan Amber J · Mcalester, OKBuilt 1973 · S/N 177RG0325 N1926FUnited Flying Club Inc · Belmont, CABuilt 1979 · S/N 17273017 N1926GJaju Aviation Inc · Abilene, TXBuilt 1974 · S/N 1026-74 N19274Jennings Lisa Nicole · Atlanta, GABuilt 1976 · S/N 17702566 N1927FSanders Herman G · Baldwyn, MSBuilt 1979 · S/N 17273018 N1928FJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17273019 N1928QWhite David D · Arcata, CABuilt 1973 · S/N 177RG0328 N1928YMaddex William E · Battle Ground, WAS/N 235 N192ACByrd Ronald D · Farwell, TXBuilt 1994 · S/N 1203-95 N192ARDj Whelan Corp · Sag Harbor, NYBuilt 1978 · S/N 17272016 N192BAHarkrader Aviation LLC · Louisa, VABuilt 1974 · S/N 459-74 N192CAVines Allen E Jr · Hoover, ALBuilt 2007 · S/N 1048-2007 N192DKLong Drive Holdings LLC · Alpine, UTS/N 17265020 N192FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1985 · S/N 15285979 N192JHHogue James B · Spencer, TNBuilt 1992 · S/N 669-92 N192MAMorgan Nigel · Asheville, NCBuilt 2014 · S/N 1137-2014 N192MKAdams Andrew T · Westlake, OHBuilt 1992 · S/N 24-3264 N1930VDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1974 · S/N 17263798 N1931VRegistered aircraftBuilt 1974 · S/N 17263799 N1932QHogan James C DBA · Cameron Park, CABuilt 1973 · S/N 177RG0332 N1932YDriver L Spence · Bay City, WIBuilt 1964 · S/N 239 N1933FVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 17273023 N1934YMack Anita · Scott Afb, ILBuilt 1964 · S/N 241 N1935YHodges William L Jr · Spotsylvania, VABuilt 1964 · S/N 289 N1936FCheek David H · Garland, TXBuilt 1979 · S/N 17273026 N19370Clanton Ronald W · Aurora, COBuilt 1968 · S/N 17257181 N1937FA2 Flight Leasing LLC · Castro Valley, CABuilt 1979 · S/N 17273027 N1937YTirado Josue · Pembroke Pines, FLBuilt 1964 · S/N 244 N19387Debo Group Inc · Uniontown, OHBuilt 1976 · S/N 17702567 N1939QGustafson Keith W · Waleska, GABuilt 1973 · S/N 177RG0339 N1939YMcconnell Kristopher P · Nampa, IDFirst renewal noticeBuilt 1964 · S/N 246 N193ACStearman Aviation Inc · Crawford, COBuilt 1993 · S/N 365-93 N193BAVonheeder Jasen T · Newport Center, VTBuilt 1978 · S/N 38-78A0083 N193GFFlattum Steven · Hampshire, ILBuilt 2006 · S/N 477-2006 N193JSRyan Moore LLC · Fayetteville, NCBuilt 1975 · S/N 17265118 N193SPIndiana State Police · Greenwood, INS/N 172-76346 N19405Blenden Stephen R · Orlando, FLBuilt 1977 · S/N 17702569 N1940FAmerican Asset Leasing LLC · Livermore, CAS/N 17273030 N1940YMiller Rollie R · Dillon, MTBuilt 1964 · S/N 247

Back to AD 80-25-07 R1