Skip to content

Registered aircraft · 6,349

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-02-R2') 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-02-R2') 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-02-R2')
    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-02-R2')
  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-02-R2')
  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-02-R2')
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.

N9539UFletchair Inc · Comfort, TXBuilt 1977 · S/N AA1C0036 N953SASunrise Aviation Inc · Ormond Beach, FLBuilt 1980 · S/N 15283908 N95404Delta State University · Cleveland, MSBuilt 1984 · S/N 15285887 N95429Suburban Air Corp · Castro Valley, CABuilt 1984 · S/N 15285892 N9542UNorman Ronald Edward · Lopez Island, WAS/N AA1C0039 N95431Kent State University · Stow, OHBuilt 1984 · S/N 15285893 N95444Kent State University · Stow, OHBuilt 1984 · S/N 15285897 N95445Kent State University · Stow, OHBuilt 1984 · S/N 15285898 N95469Kent State University · Stow, OHBuilt 1984 · S/N 15285899 N9546UFletchair Inc · Comfort, TXBuilt 1977 · S/N AA1C0042 N95474Kent State University · Stow, OHBuilt 1984 · S/N 15285901 N95475Kent State University · Stow, OHBuilt 1984 · S/N 15285902 N9547TJk Gray Family LLC · Concord, NCBuilt 1978 · S/N 38-78A0128 N9548UCharlton Daniel B · Frederick, MDBuilt 1977 · S/N AA1C0044 N9549TWilliams Dan John · Phoenix, AZBuilt 1978 · S/N 38-78A0129 N954BCCarter Bradley S · Shawnee, KSBuilt 2022 · S/N 090 N954SASunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280626 N9550UAsplundh Eric P · Bryn Athyn, PABuilt 1977 · S/N AA1C0046 N9552UStrusa Steven J · Portsmouth, VABuilt 1977 · S/N AA1C0048 N95537High Expectations LLC · Wilmington, DEBuilt 1984 · S/N 15285916 N95539Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1984 · S/N 15285917 N9553UWitowski Thaddeus J Jr · Westhampton, MABuilt 1977 · S/N AA1C0051 N95551Florida Flight Training Center · Venice, FLBuilt 1984 · S/N 15285919 N95556Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1984 · S/N 15285922 N9557ULee Henry · San Luis Obispo, CABuilt 1977 · S/N AA1C0005 N9559TGlanz William L · Central, AKBuilt 1978 · S/N 38-78A0131 N9559UDennehey Patrick N · Cameron Park, CABuilt 1977 · S/N AA1C0056 N955TTWhelan Carol · Suffield, CTBuilt 1969 · S/N AA1-0156 N95606Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1984 · S/N 15285936 N9560UBletsis Richard · Kokomo, INBuilt 1977 · S/N AA1C0057 N95615Li LLC · Seattle, WABuilt 1984 · S/N 15285938 N95626Smith Charles · Hays, NCBuilt 1984 · S/N 15285943 N9562SVon Bevern Brian J · Overland Park, KSBuilt 1966 · S/N 84 N95639Barbee Donald · Columbus, OHS/N 15285949 N9563TStone Michael S · Chamois, MOBuilt 1978 · S/N 38-78A0132 N9563UCrawford Aviation LLC · Richmond, VABuilt 1977 · S/N AA1C0062 N95646Advantage Aviation Inc · Palo Alto, CABuilt 1985 · S/N 15285951 N95670Board Of Trustees Of Southern Illinois Univ DBA · Murphysboro, ILBuilt 1985 · S/N 15285957 N9567UBerka George · Wilmington, DES/N AA1C0066 N956ERZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1978 · S/N 15282201 N956RWTrevitue LLC · San Antonio, TXBuilt 1979 · S/N 38-79A0721 N95722Frick Gregory A · Portland, ORBuilt 1985 · S/N 15285962 N95737Kent State University · Stow, OHBuilt 1985 · S/N 15285964 N9576LBusch Robert M · Duluth, MNBuilt 1976 · S/N AA1B0676 N95787Wisconsin Aviation - Four Lakes Inc · Madison, WIBuilt 1985 · S/N 15285967 N95797Kent State University · Stow, OHBuilt 1985 · S/N 15285968 N957DMCosbie Lee Roy · Tuscumbia, ALBuilt 2009 · S/N 6-6400 N95821Kent State University · Stow, OHBuilt 1985 · S/N 15285970 N95831Space Coast Aircraft Co · Merritt Island, FLBuilt 1985 · S/N 15285972 N95840Lane Community College · Eugene, ORBuilt 1985 · S/N 15285973

Back to AD 80-25-02 R2