Registered aircraft · 54,837

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-13') 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-13') 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-13')
    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-13')
  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-13')
  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-13')
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.

N1394FWeller Fred R · Saint Augustine, FLBuilt 1966 · S/N 17254889 N1394QDaugherty Keith C · Venus, PABuilt 1971 · S/N 15072694 N1394SGoodman Donald J · Bellingham, WABuilt 1976 · S/N 18264955 N1395EHendricks Paul · Yellville, ARBuilt 1978 · S/N 17270984 N1395SGarcia Robert W · Floresville, TXFirst renewal noticeS/N 18264956 N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066 N1395YEisele William Robert · Alt Loma, CABuilt 1961 · S/N 17249095 N1396YGarrison Shannon · Pangburn, ARS/N 17249096 N1397MRichs Inc · Wilmington, DES/N 21061940 N1397SKnotty Aviation LLC · Fort Myers, FLBuilt 1976 · S/N 18264958 N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068 N1397YMeyer Richard L · Fort Wayne, INBuilt 1961 · S/N 17249097 N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720 N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985 N1398SOff The Charts LLC · Kalispell, MTBuilt 1976 · S/N 18264959 N1399MRegistered aircraftBuilt 1975 · S/N 18264314 N1399SDesmond Brett Kyle · Mars, PABuilt 1976 · S/N 18264960 N1399UOc 172 Group LLC · Costa Mesa, CAFirst renewal noticeBuilt 1976 · S/N 17267070 N139BTTaylor Edward S · Billings, MTBuilt 1957 · S/N 29707 N139ERRick Aviation Inc · Newport News, VABuilt 1985 · S/N 17276532 N13BALong Arthur · Colonie, NYBuilt 1975 · S/N 15077300 N13BJSevcik Clint · Medford, MNS/N 21058486 N13CBT&W Aviation LLC · Pinehurst, TXBuilt 1981 · S/N 17274805 N13DQThaddeus Alistair Lc · New York, NYBuilt 2023 · S/N 208B5758 N13DRSchuler Edward A Jr · Hamden, CTFirst renewal noticeBuilt 1966 · S/N 15064816 N13DSR & M Adventures LLC · Wichita, KSBuilt 1980 · S/N 18267798 N13EAHood Norman R · Austin, TXBuilt 1977 · S/N 15279914 N13EFMcgough Julie Eileen · Red Oak, TXBuilt 1967 · S/N 337-0794 N13FGBaum Group LLC · Shavertown, PABuilt 1957 · S/N 34271 N13FTFenix Private Capital Group LLC · Phoenix, AZS/N P3370245 N13HKSkycombers Flying Club Inc · Pacoima, CABuilt 1972 · S/N 17701810 N13HLFreedom 421b LLC · Jacksonville, FLBuilt 1975 · S/N 421B0927 N13HWSikes Alan · Collins, GABuilt 1962 · S/N 1850290 N13JTHoltzclaw Timothy M · O Brien, FLBuilt 1972 · S/N 17261008 N13KGCarroll Jeffrey P · West Bloomfield, MIS/N 340A0215 N13KKSanders Flight Training Center Inc · Jasper, ALBuilt 1977 · S/N 17268760 N13MCMathison Neil James · Solon Springs, WIBuilt 1974 · S/N 18052444 N13MFAeromedicos Gb Inc · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 421B0253 N13NPEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 31225 N13PGJohnston Steven P · Coto De Caza, CABuilt 1976 · S/N 421C0031 N13PKOaks Aviation LLC · Clear Lake, MNBuilt 1981 · S/N 310R2127 N13SKFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17271183 N13SPNew York State Police · Latham, NYBuilt 1967 · S/N 17256431 N13TATextron Aviation Inc · Wichita, KSS/N 17276111 N13TPLehman Aviation LLC · Remington, INBuilt 1976 · S/N 17267454 N13WSJohnson Chad H · Houston, TXBuilt 1979 · S/N 18503938 N13WTBentz George T · Missoula, MTBuilt 1973 · S/N 18262089 N13WWHurd Steven C · Bangor, MEBuilt 1982 · S/N 18504378 N13YPBlock Scott M · Chandler, AZBuilt 1968 · S/N 17257055 N1400Salour Michael M · Carlsbad, CABuilt 1979 · S/N P210-00277

Back to AD 97-01-13