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.

N12960Hennessee Timothy H · New Braunfels, TXBuilt 1973 · S/N 17262405 N12968Rtd Aviation LLC · Hillsborough, NJBuilt 1973 · S/N 17262413 N1296CLogan Tom B Trustee · Coeur D Alene, IDBuilt 1977 · S/N 17702699 N1296FWalker Brandon · Anchorage, AKBuilt 1975 · S/N 18502816 N1296GAir Dogs LLC · Watford City, NDBuilt 1976 · S/N 310R0698 N1296QFey Brian F · Waycross, GABuilt 1971 · S/N 15072596 N1296STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 208B1296 N1296UKirk Claire Y · Huntington Beach, CABuilt 1976 · S/N 17266990 N1296YPa1 208b-1079 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1079 N12973Mor Aviation LLC · Gaithersburg, MDBuilt 1973 · S/N 17262418 N12974Forest Ken W · Wales, NDBuilt 1972 · S/N 17262419 N12976Wanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1973 · S/N 17262421 N1297FJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272990 N1297GPilot Mountain Aviation LLC · Marietta, OHBuilt 1974 · S/N 310R0003 N1297SAlpine Skylane LLC · Alpine, WYS/N 18264864 N12983Haman Aviation Services LLC · Nokomis, FLBuilt 1973 · S/N 17262427 N12984Go Fly Az LLC · Gilbert, AZBuilt 1975 · S/N 17702394 N12985Alamakee Flyers · Waukon, IABuilt 1973 · S/N 17262429 N1298MRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 18264280 N1298SHighlane LLC · Phoenix, AZBuilt 1976 · S/N 18264865 N12991Usda Forest Service Fepp · Columbia, SCBuilt 1973 · S/N 17262432 N12997Wausau Flying Service Inc · Wausau, WIS/N 17262437 N1299MMoanaviation Inc · Tampa, FLBuilt 1977 · S/N 21061932 N1299SAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264866 N1299URice Melvin G · Bridgeport, TXBuilt 1976 · S/N 17266993 N129AHN388vr LLC · Olalla, WABuilt 1963 · S/N 17251051 N129ASPyxis Air LLC · Wilmington, DEBuilt 1976 · S/N 310R0663 N129CGSchuman Carriage Co Ltd · Honolulu, HIBuilt 2007 · S/N 208B1290 N129CSGoldenstein Steven H Jr · Jurupa Valley, CABuilt 1975 · S/N 18264167 N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374 N129FRWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17275338 N129KTFowler Andy D · Anchorage, AKBuilt 1975 · S/N 18502812 N129LPJag Aviation LLC · Belle Chasse, LABuilt 1980 · S/N 18504088 N129MLarkin Marion J · Salome, AZBuilt 1973 · S/N 18502208 N129MDMiller Glen S · Brenham, TXS/N 56430 N129PRRasmussen Paul B · Long Lake, NYBuilt 1968 · S/N 185-1448 N129SAero Quest LLC · Olive Branch, MSBuilt 1974 · S/N 17263118 N129SLLee Aero LLC · Wichita, KSBuilt 1979 · S/N 17273503 N129SYDaigle Danny · Greenville, MEBuilt 1978 · S/N 17270741 N129VRecovery One Services LLC · Georgetown, KYBuilt 1979 · S/N 18267444 N12ASNewman Scott W · Healdsburg, CABuilt 1973 · S/N 18502271 N12AWTgam LLC · Toppenish, WABuilt 1978 · S/N U20604688 N12BCCentral Ohio Flyers Assn · Columbus, OHBuilt 1973 · S/N 18261895 N12BJValentour Lance F · Naperville, ILBuilt 1974 · S/N 17264570 N12CHKetchum Christensen Sky Chasers LLC · Midwest City, OKBuilt 1966 · S/N 18257291 N12CRTrudnak Michael W · Mansfield Center, CTBuilt 1977 · S/N 421C0279 N12CYYeagle Aviation Inc · Port Saint Lucie, FLBuilt 1971 · S/N 310Q0247 N12DMIsland Airways LLC · Marion, WIBuilt 1976 · S/N 18502947 N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202 N12EABrown Gary Ashton · Simpsonville, SCS/N 15279903

Back to AD 97-01-13