Registered aircraft · 6,915

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-01-R1') 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-01-R1') 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-01-R1')
    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-01-R1')
  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-01-R1')
  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-01-R1')
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.

N41WAHackler Jeanette D · Arlington, TXBuilt 1967 · S/N 28R-30211 N41ZMMindwinder Inc · Reno, NVBuilt 1977 · S/N 34-7870018 N4217TBentzen David A · Deer Park, WABuilt 1968 · S/N 28R-30975 N422SCAg Air Squadron One LLC · Saint Joseph, ILBuilt 1967 · S/N 28R-30022 N4236PRegistration Pending · Chandler, AZRegistration pendingS/N 24-1260 N423CCAllen Stephen David · Los Banos, CABuilt 1978 · S/N 28R-7803368 N424BHTouchdown Arkansas LLC · Batesville, ARBuilt 1976 · S/N 32R-7780016 N424RMEast End Grill Management Co LLC · Memphis, TNBuilt 1977 · S/N 32R-7780306 N424TPHarris Joseph · Bradenton, FLBuilt 1977 · S/N 32R-7780332 N424WTLumberton Air 1 LLC · Mount Laurel, NJBuilt 1973 · S/N 34-7350142 N4250Leafgreen Jeff A Trustee · Lander, WYBuilt 1959 · S/N 24-894 N425DPKuhn Alexander G · Fairfield, CTBuilt 1978 · S/N 28R-7837174 N425JVBarnes Timothy K · Chapel Hill, NCBuilt 2004 · S/N 2844112 N4269WZeek Michael · Munfordville, KYFirst renewal noticeS/N 30-1258 N4284Clements Eric C · Sheridan, WYBuilt 1965 · S/N 24-4284 N428663 Elm Terrace LLC · Waterville, MEBuilt 1974 · S/N 34-7450173 N428FClark Robert D · Bedford, NHBuilt 1969 · S/N 28R-35201 N428RJSeneca Ez LLC · Weston, FLBuilt 1975 · S/N 347570250 N4297ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N 39-114 N429TLLong Tracey · Cleveland, TNBuilt 1974 · S/N 34-7570001 N42HHHageness Donna L · Rolette, NDBuilt 1977 · S/N 34-7770093 N42PGWright Charles E · Hebron, KYBuilt 1977 · S/N 28R-7703353 N42PMJofredo Corp · Zephyrhills, FLBuilt 1969 · S/N 30-1932 N42TPBalkin John S · Bigfork, MTBuilt 1964 · S/N 30-255 N43014Woodworth Neal A · Geneva, OHBuilt 1974 · S/N 28R-7435241 N4301FNewberg Curtis · Willmar, MNBuilt 1976 · S/N 32R-7680433 N4302XJin Jin Aviation LLC · Anchorage, AKBuilt 1975 · S/N 28R-7635005 N43034A S Flight Academy LLC · Lantana, FLBuilt 1974 · S/N 34-7450175 N4304XC W Rose Flight LLC · Wilmington, DEBuilt 1976 · S/N 34-7670018 N43062Burgraff William B · Palatine, ILBuilt 1974 · S/N 28R-7435245 N4306FN4306f Inc · Winter Haven, FLBuilt 1976 · S/N 32R-7680434 N4306TKaszynski John · Porter Ranch, CABuilt 1971 · S/N 28R-7235004 N430AVN1534x LLC · Manassas, VABuilt 1975 · S/N 28R-7535313 N430MMMersereau Iden H · Goodyear, AZBuilt 1966 · S/N 24-4525 N430SLRegistered aircraftBuilt 1976 · S/N 32R-7680274 N43130University Of Maryland Eastern Shore · Princess Anne, MDBuilt 1974 · S/N 34-7450180 N43134Minot Aero Center · Minot, NDS/N 34-7450150 N4314FAllred Karl T · Evanston, WYS/N 28R-7635399 N4316FRolen Dale Shane · Benbrook, TXBuilt 1976 · S/N 32R-7680435 N4317XRing Toby C · Tuscola, ILBuilt 1975 · S/N 32R-7680010 N43183Isbell Brian K · Rosenberg, TXBuilt 1974 · S/N 28R-7435251 N431ABAirtrust LLC - 18 - Series 18 Trustee · Sheridan, WYS/N 24-4156 N431PAGharazeddine Raja N · Kaplan, LABuilt 2001 · S/N 2844048 N431WRettenmaier Kim J · Columbia, MOBuilt 1969 · S/N 28R-35277 N43215Gremel Tyler · Ellensburg, WABuilt 1974 · S/N 28R-7435254 N4321FVales Louis · Monroe, NYBuilt 1976 · S/N 28R-7635455 N4321TSale Reported · Signal Hill, CASale reportedBuilt 1971 · S/N 28R-7235007 N4322FAdk Xc Flyers LLC · Scotia, NYBuilt 1976 · S/N 28R-7635456 N4323FMisty Aviation LLC · Wilmington, DEBuilt 1976 · S/N 32R-7680507 N4323TBreitenstine Matthew · Dallas, TXBuilt 1971 · S/N 28R-7235008

Back to AD 97-01-01 R1