Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N7852YBordlemay John J · Lewisberry, PABuilt 1965 · S/N 30-932 N7855YParrish Aviation Flight Academy LLC · Southlake, TXBuilt 1965 · S/N 30-936 N7856YEastern Technical Corp · Martinsburg, WVBuilt 1965 · S/N 30-937 N7857FGeorge William Jesse · Alamogordo, NMBuilt 1976 · S/N 32R-7780084 N7858YGraham Stuart H · Heath, OHBuilt 1965 · S/N 30-778 N785CGWings Of Victory Worldwide LLC · Apopka, FLS/N 34-7770351 N7860PValley Aircraft Management Inc · Visalia, CABuilt 1962 · S/N 24-3083 N7861PSparks James R · Maxwelton, WVBuilt 1962 · S/N 24-3085 N7861Y7861y LLC · Long Beach, CAS/N 30-942 N7862YSteiger Michael P · Cypress, TXBuilt 1965 · S/N 30-944 N7863PMicheletti Joe A · Lake Almanor, CABuilt 1962 · S/N 24-3088 N7863YSlipshod Aviation LLC · Hurricane, UTBuilt 1965 · S/N 30-945 N7864YVavra Loren · Phoenix, AZFirst renewal noticeBuilt 1965 · S/N 30-946 N7865PGear Down Hangar LLC · Phoenix, AZBuilt 1962 · S/N 24-3090 N7865YMussman Craig L · Grant Park, ILBuilt 1965 · S/N 30-948 N7866PGcsb Enterprises LLC · Oklahoma City, OKBuilt 1963 · S/N 24-3091 N7866YHenrie Aviation LLC · Fairfield, NJBuilt 1965 · S/N 30-949 N7868FC & R Aero Inc · Marco Island, FLBuilt 1976 · S/N 32R-7780085 N786BGGross Kyle F · Salt Lake City, UTBuilt 2006 · S/N 2844126 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 N787BGWestchester Flying Club Inc · Purchase, NYBuilt 2002 · S/N 2844085 N787KSWalden Franklin S · Southern Pines, NCBuilt 1964 · S/N 24-3644 N787PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350033 N787WAJw Aero Holdings Inc · Canandaigua, NYBuilt 1980 · S/N 348070057 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 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 N7893PBas Part Sales LLC · Greeley, COS/N 24-3122 N7893YRegistered aircraftBuilt 1966 · S/N 30-980 N7898PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 301873 N7898YPatry Aeronautical Institute · Kalispell, MTBuilt 1966 · S/N 30-986 N78AARw Higginsllc · Armuchee, GABuilt 1977 · S/N 32R-7780239 N78DJKing David V · Mars, PABuilt 1978 · S/N 28R-7837171 N78PWPower Joe D · Seguin, TXBuilt 1963 · S/N 24-3434 N78QBPandion Aviation LLC · West Chester, PABuilt 1978 · S/N 28R-7837308 N78RJUsaeroflight LLC · Greenville, SCBuilt 1970 · S/N 39-21

Back to AD 97-01-01 R1