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.

N1400FBingham Edward K · Buchanan, GABuilt 1966 · S/N 17254895 N1400UTino Frank V Jr · Miami, FLBuilt 1960 · S/N 15059024 N1401EUnited States Air Force Aero Club · Usaf Academy, COBuilt 1978 · S/N 17270986 N1402FRegistration Pending · Pomona, CARegistration pendingBuilt 1966 · S/N 17254897 N1402SJohnston Matthew A · Ventura, CABuilt 1976 · S/N 18264962 N1402YRg Enterprises LLC · Tullahoma, TNBuilt 1961 · S/N 17249102 N1403FGoedeker Jr Werner F · Waterville, NYBuilt 1966 · S/N 17254898 N1403SFarnsworth Scott · Crestwood, KYBuilt 1976 · S/N 18264963 N1403VSmith Dennis A Trustee · Salem, ORBuilt 1974 · S/N 17263550 N1404CAeroscalper LLC · Goshen, INBuilt 1977 · S/N 17702721 N1404SRegistration Pending · Englewood, CORegistration pendingS/N 18264964 N1405MWilson George W · Tucson, AZBuilt 1975 · S/N 18264318 N1405SVickers David A · Douglas, GABuilt 1976 · S/N 18264965 N1405UGuardian Aerial Patrol LLC · Edmond, OKBuilt 1976 · S/N 17267075 N1405YImrich Thomas S · Mercer Island, WABuilt 1961 · S/N 17249105 N1406CMcaninch Danny Ray · Pleasant Hill, CABuilt 1977 · S/N 17702722 N1406MHeisler Jon S · Auburn, WABuilt 1954 · S/N 30851 N1407SCaesar Wings LLC · Ubly, MIBuilt 1976 · S/N 18264967 N1407UN R I Flying Club · Walnut Creek, CABuilt 1976 · S/N 17267077 N14084Chizek Terry L · Marion, KSBuilt 1960 · S/N 17944 N1408CHaworth Michael R · Riverside, CABuilt 1977 · S/N 17702723 N1408SFrickel Well Service LLC · Atkinson, NEBuilt 1976 · S/N 18264968 N1408YShawver Aviation LLC · Knoxville, IABuilt 1961 · S/N 17249108 N1409QDjz Aviation LLC · Kalispell, MTBuilt 1971 · S/N 15072709 N140ASAircraft Structures International Corp · Enid, OKS/N 208B0633 N140FPNorthwoods Air LLC · Orono, MEBuilt 1986 · S/N 17276539 N140JRobert D Grace LLC · Amarillo, TXBuilt 1981 · S/N 414A0650 N140KMKnight Edge LLC · Clearwater, FLBuilt 1981 · S/N 414A-0674 N140MAMindy Limited LLC · Muscatine, IABuilt 1970 · S/N 15072399 N140PCNavigation Leasing LLC · Castle Rock, COBuilt 1976 · S/N 17268241 N140RFAv Serv LLC · Dover, DES/N 208B0656 N140RWTarara Chad L · Webster, MNBuilt 1973 · S/N 15074478 N140TPHickox Joseph · Rollins, MTS/N 340A0235 N140WTFly Whiskey Tango LLC · Scottsdale, AZBuilt 1984 · S/N 17276201 N1410GSierra-Mike LLC · Springdale, ARS/N 15073205 N1410MRapp Steven W · Boulder City, NVBuilt 1971 · S/N 18260580 N1410YMolohan Ronald M · Elk Grove, CABuilt 1961 · S/N 17249110 N1411FKrause Alex D II · Clintonville, WIBuilt 1966 · S/N 17254906 N1411UOxley Kevin L · Huntington, INBuilt 1976 · S/N 17267080 N1411VForbes David · Garden Grove, CABuilt 1976 · S/N R1722186 N1412QOconnor Melanie Faith · Flagler Beach, FLBuilt 1971 · S/N 15072712 N1412SJ&J Aviation LLC · Thedford, NEBuilt 1976 · S/N 18264971 N1413FWitmer Brendle D · Woodbury, PABuilt 1966 · S/N 17254908 N1413QWolf John C · Bethel, PABuilt 1971 · S/N 15072713 N1413SAgillaire Inc · Colleyville, TXS/N 18264972 N1413VMercury International LLC · Cheyenne, WYS/N R1722187 N1413YSooter Craig A · Sedgwick, KSBuilt 1961 · S/N 17249113 N1414CSorby Steven R · Lyman, WABuilt 1966 · S/N 337-0419 N1414FPalmer Matthew B · Riverside, CABuilt 1966 · S/N 17254909 N1414QForsman Robert J · Jber, AKBuilt 1971 · S/N 15072714

Back to AD 97-01-13