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.

N1459EN Hollywood Optimist Club Youth & Comm Svc Fndtn · Van Nuys, CABuilt 1978 · S/N 17271007 N1459FGostecnik Gary · Brookshire, TXBuilt 1966 · S/N 17254954 N1459MK And L Aviation Incorporated · Wilmington, DEBuilt 1969 · S/N U20601459 N1459VRegistration Pending · Portsmouth, NHRegistration pendingBuilt 1974 · S/N 17263596 N1459YBriere Mark E · Mims, FLBuilt 1962 · S/N 17249159 N145GPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 20800722 N145JKArcus Aero LLC · Bridgeport, TXBuilt 1965 · S/N 18051549 N145KAKamaka Air LLC · Honolulu, HIBuilt 2008 · S/N 208B2019 N145MLKuonen Christopher · Wellsboro, PABuilt 1976 · S/N 17268382 N145PPainter Bryan J · Renton, WABuilt 1963 · S/N 205-0332 N145PLState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606141 N145SWShore Gerry · Inez, TXBuilt 1973 · S/N 310Q-0614 N145TTVenture Air Solutions Inc · Dallas, GABuilt 1977 · S/N 402B1333 N145WAMartinaire Aviation LLC · Addison, TXBuilt 2005 · S/N 208B1145 N1460FConrad William A · Freedom, WIBuilt 1966 · S/N 17254955 N1460VCk Leasing Services LLC · Wilmington, DES/N 17263597 N1461EOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271009 N1461QMarquez Christopher D · Fleming Island, FLBuilt 1971 · S/N 15072761 N1461UKettle Peter · Fitchburg, MABuilt 1976 · S/N 17267128 N1461YKarpov Vladimir · Raymond, NES/N 17249161 N1462FLambdin Charles Randall · Wolf Lake, ILBuilt 1966 · S/N 17254957 N1462SRiverside Aviation LLC · Oakland, IABuilt 1976 · S/N 18265009 N1463E1463 Echo LLC · Eau Claire, WIS/N 17271010 N1464ERegistration Pending · New Windsor, NYRegistration pendingBuilt 1978 · S/N 17271011 N1464SRauch Andrew J · Timnath, COBuilt 1976 · S/N 18265011 N1465EDandelion Wine LLC · Charleston, SCBuilt 1978 · S/N 17271012 N1465MBig Mountain Construction LLC · La Grande, ORBuilt 1969 · S/N U20601465 N1466FGoody Birds LLC · Prattville, ALBuilt 1979 · S/N 17273005 N1466MTabor Shayne · Renville, MNBuilt 1970 · S/N U20601466 N1466SCombs Brent L · Dallas, SDBuilt 1976 · S/N 18265013 N1466UConcepcion Leonardo · Downey, CAS/N 17267133 N1466VGak Flight LLC · Scandia, MNBuilt 1974 · S/N 17263603 N1467FJetceo LLC · Kalispell, MTBuilt 1975 · S/N 18502845 N1467VLumpkin Aviation LLC · Dahlonega, GABuilt 1976 · S/N R1722194 N1468MArctic Barnabas Ministries · Kenai, AKBuilt 1970 · S/N U20601468 N1468VMonmouth Flying Club · Monmouth, ILBuilt 1974 · S/N 17263605 N1469FSkywagon 185 LLC · Ocala, FLBuilt 1975 · S/N 18502847 N1469SS & J Farms · Floydada, TXBuilt 1976 · S/N 18265016 N146ACUnited States Air Force Owner · Usaf Academy, COBuilt 1967 · S/N R1720147 N146EN146e LLC · Thomasville, GABuilt 1982 · S/N 18268292 N146FCUsda Forest Service Fepp · Malvern, ARBuilt 1966 · S/N P206-0247 N146GWBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 425-0146 N146JHGodinez Mauricio U · San Diego, CAS/N 15066426 N146TJBirdboys2 Aviation LLC · Boerne, TXBuilt 1978 · S/N 421C0500 N146WMWatermakers Air Inc · Fort Lauderdale, FLBuilt 2000 · S/N 208B-0813 N146YBayer Peter D · Naperville, ILBuilt 1955 · S/N 32098 N1470QHillyer Joe F · Soldotna, AKBuilt 1977 · S/N 18503483 N1470UScientific Aerial Imaging Inc · Saint Helena, CABuilt 1976 · S/N 17267137 N1470VGiron Lawrence N · Anchorage, AKBuilt 1974 · S/N 17263607 N1471EKdrd Holdings LLC · Texas City, TXBuilt 1978 · S/N 17271014

Back to AD 97-01-13