Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N7866YHenrie Aviation LLC · Fairfield, NJBuilt 1965 · S/N 30-949 N786AAtp Aircraft 2 LLC · Wilmington, DEBuilt 1997 · S/N 4496016 N7871YDow Jeff W · Port Hadlock, WAS/N 30-955 N7873PKirtley Kevin R · Boise, IDBuilt 1962 · S/N 24-3099 N7875P3 Commanches Aviation LLC · Williamston, SCBuilt 1962 · S/N 24-3101 N7875YDodson Carl F · Jasper, INBuilt 1965 · S/N 30-959 N7876PCrouse Gregory T · Napa, CABuilt 1962 · S/N 24-3102 N7877PMiller Kenneth · Jennings, LAS/N 24-3103 N7879PKeenan Matthew J · Clearwater, FLBuilt 1962 · S/N 24-3105 N787ANDixon Richard W · Laytonsville, MDBuilt 1962 · S/N 24-3308 N787AUAuburn University · Auburn, ALBuilt 2019 · S/N 4496457 N787KSWalden Franklin S · Southern Pines, NCBuilt 1964 · S/N 24-3644 N7880KMattingley Kenneth R · Willow, AKBuilt 1953 · S/N 22-937 N7882PWaters Robert D · Albuquerque, NMBuilt 1962 · S/N 24-3110 N7883PFinke Michael C · Pleasant Prairie, WIBuilt 1962 · S/N 24-3111 N7883YHoward Jerry W · Snellville, GABuilt 1965 · S/N 30-968 N7885YKregel Steven · Garnavillo, IABuilt 1965 · S/N 30-970 N7887P7887papa LLC · Glenwood Springs, COBuilt 1962 · S/N 24-3116 N7887YAskins Jack C · Wichita Falls, TXBuilt 1966 · S/N 30-973 N7888YBurkel Robert G · Hemet, CABuilt 1966 · S/N 30-975 N788BGSeminole Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 4496143 N7890YMhr Leasing LLC · Hickory Corners, MIBuilt 1966 · S/N 30-977 N7891PN7891p Partners LLC · Suffolk, VABuilt 1962 · S/N 24-3120 N7892YHarrison Richard J · South Hamilton, MABuilt 1966 · S/N 30-979 N7893DMoes John E · Manchester, IABuilt 1957 · S/N 22-5516 N7893PBas Part Sales LLC · Greeley, COS/N 24-3122 N7893YRegistered aircraftBuilt 1966 · S/N 30-980 N7896DJohnson Rickie G · Callahan, FLBuilt 1957 · S/N 22-5522 N7898PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 301873 N7898YPatry Aeronautical Institute · Kalispell, MTBuilt 1966 · S/N 30-986 N7899DBlake Richard E Jr · Marion, LABuilt 1958 · S/N 22-5819 N789AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 4496623 N78GSAir Mods And Repair Corp · Robbinsville, NJBuilt 1972 · S/N 27-4833 N78JT71793 LLC · San Luis Obispo, CABuilt 1978 · S/N 27-7854138 N78LJValiair Lc · Casper, WYBuilt 1973 · S/N 27-7304943 N78PWPower Joe D · Seguin, TXBuilt 1963 · S/N 24-3434 N78RFFairchild Maxwell D · Morristown, TNBuilt 1958 · S/N 22-6243 N78RJUsaeroflight LLC · Greenville, SCBuilt 1970 · S/N 39-21 N7900PGoco Wireless Inc · Goliad, TXBuilt 1962 · S/N 24-3130 N7900YLone Star Aircraft Holding Group LLC · Plano, TXS/N 30-987 N7901YHinshaw Eric C · Lake Wales, FLBuilt 1966 · S/N 30-988 N7902YCohn David · Port Townsend, WABuilt 1966 · S/N 30-990 N7903PCaple Colby L · Windsor, COS/N 24-3133 N7905PComanche250 LLC · Sequim, WAS/N 24-3136 N7905YPatterson Thomas A · Minerva, OHBuilt 1966 · S/N 30-994 N7907PSchwartz Tyson E · Midland, TXBuilt 1961 · S/N 24-3138 N790AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2026 · S/N 4496641 N790BBBeitel Robert R · Lake Wylie, SCBuilt 1968 · S/N 27-4023 N790GKAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1979 · S/N 44-7995316 N790NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2017 · S/N 4496405

Back to AD 85-02-05 R1