OpenAirDocs.org
AD 54-02-01

Registered aircraft · 2,230

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
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:54-02-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:54-02-01')
  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.

N1008ZKimbrel Mark D · Rochester, WABuilt 1961 · S/N 1N100SXKing Samuel E · Battle Mountain, NVBuilt 1951 · S/N 18-709N1011AMachamer John K · Gettysburg, PABuilt 1950 · S/N 18-582N1017AEllis Wendell K · Gakona, AKBuilt 1950 · S/N 18-587N101F5g Air LLC · Rhome, TXBuilt 1959 · S/N 7HC-11N101RZRay Roger C · Mcminnville, ORBuilt 2001 · S/N 792N102JTBrady George K · Rose Hill, KSBuilt 1997 · S/N 190N102LEChabolla Miguel · Tucson, AZBuilt 1981 · S/N 102N102TRegistration Pending · Anchorage, AKRegistration pendingBuilt 1954 · S/N 18-2216N102WRSt Onge Adam R · Sterling, AKBuilt 1952 · S/N 20-919N1030TZamora Milamaedelza · Panorama City, CAS/N 65N1034AHawk Don · Shady Cove, ORS/N 18-606N10365Air Heritage Inc · Beaver Falls, PABuilt 1954 · S/N 54-2533N1039DPetro Jerry R · Williamsburg, VABuilt 1982 · S/N 50N10404Powers Phillp K · Tallulah, LAS/N 18-3561N1041AWinkelman Donald L · Anchorage, AKBuilt 1951 · S/N 18-619N1043KShadowens Jackie R · Sapulpa, OKBuilt 1954 · S/N 18-3919N1045ALange Bryan C · Harrison, NEBuilt 1951 · S/N 18-622N1045BBigger Val J · Las Cruces, NMBuilt 2023 · S/N VBKD-1N1046ZAvery Robert K · Fort Worth, TXBuilt 1970 · S/N WLB-1N1050AMcmahan Charles B · Gakona, AKBuilt 1951 · S/N 18-628N1051ARegistered aircraftBuilt 1951 · S/N 18-641N1051QJacobsen Gary James · Yelm, WABuilt 1979 · S/N 802N10572Jefferson Jake O · Wasilla, AKS/N 18-933N10579Cottrell Mark · Leitchfield, KYBuilt 1979 · S/N 121613N10593Jones Thomas E · Crestline, CABuilt 1958 · S/N 18-893N1059AButler Billy D · Hilger, MTBuilt 1951 · S/N 18-630N105DMMedcalf Danny J · Republic, MOBuilt 2003 · S/N 6-3953N1065ANordhaus Robert · Lake Geneva, WIBuilt 1951 · S/N 18-648N1066AYounggren James H · Hallock, MNBuilt 1951 · S/N 18-646N1069ALemmer Mark D · Atkinson, NEBuilt 1951 · S/N 18-652N106JDBaker Zachary · Coeur D Alene, IDS/N 166N1072AScarboro Thomas E · North Pole, AKBuilt 1951 · S/N 18-655N1073APeters Steven M · Parkersburg, WVBuilt 1951 · S/N 18-657N1075ABates Hobart C · Dexter, MIBuilt 1951 · S/N 18-667N1078AHall Alan R · Enumclaw, WABuilt 1957 · S/N 18-662N10792Wingnut Inc · Wilmington, DEBuilt 1931 · S/N 102N10804Openshaw Charles · Huggins, MOBuilt 1972 · S/N 1N1081AHoyer Larry B · Fort Peck, MTBuilt 1951 · S/N 18-663N1087AScotton Bradley D · Galena, AKBuilt 1951 · S/N 18-673N1089AReeder Julian S Jr · Nenana, AKS/N 18-680N1089ZWilson Clayton A · Kirkville, NYBuilt 1964 · S/N HE11N1097ARanch Aero LLC · Sterling City, TXS/N 18-685N1099PHansen K Brent · Captain Cook, HIS/N 20-510N109TWerba Bruce J · Holy Cross, AKBuilt 1952 · S/N 18-2223N10CFUrwin Keith · Warren, ORBuilt 2014 · S/N 203N10DDFrasca Air Museum Inc · Urbana, ILBuilt 1974 · S/N 1N10TKKerns Thomas R · Hopkins, MNBuilt 1982 · S/N 71N1100CGraves Robert E · Danville, INS/N 20-955N11011Gilman Trevor J · North Adams, MABuilt 1968 · S/N 001
Back to AD 54-02-01