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.

N31694Rey Al · Burlington, NCBuilt 1978 · S/N 28R-7837244 N316APAntofiami Flying Circus Inc · Wilmington, DEBuilt 1976 · S/N 32R-7680210 N316EFLibra Air Inc · Las Vegas, NVBuilt 1974 · S/N 28R-7435172 N316XKinney Shawn M · Camp Verde, AZBuilt 1969 · S/N 28R-35670 N31734Oscar Air LLC · Bethlehem, PABuilt 1978 · S/N 28R-7837246 N3173RRona LLC · Phoenix, AZBuilt 1969 · S/N 28R-31121 N3174RSeifert Richard W · Big Bear City, CAS/N 28R-31122 N3177RLaviano Kenneth J · Westwood, NJBuilt 1969 · S/N 28R-31125 N31799Kaschmitter Enterprises Inc · Grangeville, IDBuilt 1978 · S/N 34-7870266 N317NCField Daniel James · Bloomfield, CTS/N 28R-7635439 N317RJN317rj Inc · Maitland, FLBuilt 1966 · S/N 30-1249 N31870Flight Level Aviators LLC · Glendale, AZBuilt 1978 · S/N 28R-7803302 N3189QBoll Weevil Flyers LLC · Reedville, VABuilt 1977 · S/N 28R-7737049 N31906Bosveld Bobby J · Markesan, WIBuilt 1978 · S/N 28R-7837254 N31913Southern Aircraft LLC · Valdosta, GABuilt 1978 · S/N 34-7870275 N31930Patrick Juan Hughes · Hernando, FLBuilt 1978 · S/N 28R-7803305 N31950Kasparie Ronald · Quincy, ILBuilt 1978 · S/N 28R-7837259 N31970Benefield John H Jr · Cedartown, GABuilt 1978 · S/N 28R-7837260 N31994Montrose Douglas K · Glen Ellyn, ILS/N 28R-7803307 N31999Kealy Kevin · Las Vegas, NVBuilt 1978 · S/N 34-7870284 N31BKBlackwell Derek G · Florence, SCBuilt 1977 · S/N 32R-7780545 N31TLT M L Aircraft Inc · Narrowsburg, NYS/N 28R-7235314 N31VUJav Enterprises LLC · Broomfield, COBuilt 2018 · S/N 2844179 N31WHDerbecker David G · Katy, TXBuilt 1969 · S/N 24-4810 N3200RTexeira David A · Venice, FLBuilt 1969 · S/N 28R-31126 N32015Rock Solid Aviation LLC · Lake Charles, LABuilt 1974 · S/N 34-7570007 N32020N32020 LLC · Springfield, MOBuilt 1974 · S/N 28R-7535015 N32047Sat Aircraft LLC · Clermont, FLBuilt 1974 · S/N 28R-7535018 N3207RLingerfelt Joseph A · Woodburn, ORBuilt 1969 · S/N 28R-31129 N320GCNordquist Mark O · Petaluma, CABuilt 1970 · S/N 39-60 N320JLInspired Oasis LLC · Salem, ORBuilt 1969 · S/N 244886 N320MRSic Direct Aviation Inc · Kingwood, TXBuilt 1969 · S/N 30-1917 N32129Weaver Arnold G · Sandusky, MIS/N 28R-7535028 N3216Ropp Dwight F · Pasco, WAS/N 30-796 N3216QSoma 1953 LLC · Arcadia, FLBuilt 1977 · S/N 28R-7703097 N32172International Aviation Group LLC · Lake Wales, FLBuilt 1974 · S/N 28R-7535030 N32196Overstreet Bradley · Greenville, SCBuilt 1974 · S/N 28R-7535034 N3219RSotelo Aviation LLC · Naples, FLBuilt 1969 · S/N 28R-31132 N321CNInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28R7803166 N3225RHansen Duane D · Rockford, ILBuilt 1969 · S/N 28R-31134 N3227QBrands Robert C · Cary, NCS/N 32R-7780299 N3228PPopejoy Marc · Fort Scott, KSBuilt 1958 · S/N 24-294 N3228QR&G Aviation LLC · Jonesboro, ARS/N 32R-7780300 N32294Cloud Dancer Aviation Inc · Deland, FLBuilt 1974 · S/N 28R-7535041 N3229QHansen Ralph H Jr Trustee · Encinitas, CABuilt 1977 · S/N 34-7770222 N322CARoyal Majesty Aviation LLC · Atlanta, GAS/N 28R-7130013 N322FCFuego Enterprises Inc · Atlanta, GABuilt 2003 · S/N 3449275 N322HCClover Park Technical College · Tacoma, WABuilt 1969 · S/N 28R-31096 N322JK & M Aviation LLC · West Liberty, KYS/N 24-1316 N322SSJohnson Robert Wayne · Lebanon, TNBuilt 1978 · S/N 28R-7803353

Back to AD 97-01-01 R1