Registered aircraft · 40,471

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

N9631BPercy Flyers LLC · Dexter, MIBuilt 1981 · S/N 172RG0930 N9631CThompson Joseph D · Alliance, NEBuilt 1978 · S/N 28-7890431 N9631QHuntsman Ferral Don · Juneau, AKBuilt 1975 · S/N 17265715 N9631RBw Flying Association · Seattle, WABuilt 1959 · S/N TD-314 N9631UCross Scott · Scott Township, PABuilt 1975 · S/N AA5-0831 N9631VHarrold Bruce E · Greybull, WYBuilt 1974 · S/N 17264411 N9632HSweitz-Air Inc · Stewartstown, PAS/N 17266279 N9632JAirbrain Aviation Inc · Snellville, GABuilt 1966 · S/N 28-3789 N9633HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266280 N9633UMoseley Warren C · Haslet, TXBuilt 1977 · S/N AA1C0078 N9633WFladager Enterprises Inc · Peerless, MTBuilt 1967 · S/N 28-23090 N9634DBacklund Scott W · Greybull, WYBuilt 1959 · S/N 22-6546 N9634QDubois County Flight Services Inc · Huntingburg, INBuilt 1975 · S/N 17265718 N9634WShinar Philip C · California City, CABuilt 1967 · S/N 28-23091 N9635BFisher Frank L · San Diego, CABuilt 1981 · S/N 172RG0933 N9635HArizona Aircraft Leasing LLC · Mesa, AZBuilt 1975 · S/N 17266282 N9635LAcme Club Training Inc · Anchorage, AKBuilt 1986 · S/N 17276592 N9635QRozynski Jason K · Malabar, FLBuilt 1975 · S/N 17265719 N9635UCarmichael Donald L · Carlisle, INBuilt 1975 · S/N AA5A-0001 N9635V35 Victor LLC · Decatur, GABuilt 1974 · S/N 17264415 N9635WGordon David · Long Branch, NJBuilt 1967 · S/N 28-23092 N9636HMontanez Orlando · Guaynabo, PRBuilt 1975 · S/N 17266283 N9636JPorter Julia N · Pflugerville, TXBuilt 1966 · S/N 28-3833 N9636LWest Main Auto Sales Inc · Tupelo, MSBuilt 1974 · S/N AA5-0636 N9636RTrans West Specialties · Visalia, CAS/N TD-317 N9636USchroeder Wolf Udo · Rochester, NYBuilt 1975 · S/N AA5A-0002 N9636VNaperville Flying Club · Woodridge, ILBuilt 1974 · S/N 17264416 N9637DSpivey Harold E · Thomaston, GABuilt 1959 · S/N 22-6549 N9637QWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17265721 N9638CJones Francis P Jr · Newport, ARBuilt 1978 · S/N 28-7816507 N9638HHatbright Farm LLC · Wilmington, DEBuilt 1975 · S/N 17266285 N9638JPrince Jennifer R · Farr West, UTBuilt 1967 · S/N 28-3867 N9638QPeterson John E · Benton, KSBuilt 1975 · S/N 17265722 N9638VCrazy Aces LLC · St George, UTBuilt 1974 · S/N 17264418 N9639CNichols Brian J · Mount Hope, WIBuilt 1978 · S/N 28-7816508 N9639DVestal James L · Kernersville, NCBuilt 1959 · S/N 22-6552 N9639UAslaksen Jay P · Richmond, TXBuilt 1975 · S/N AA5A-0005 N9639WUlmer Daniel J · Menno, SDBuilt 1967 · S/N 28-23097 N963CCMansfield Heliflight Inc · Milton, VTBuilt 1989 · S/N 1013 N963EAEcho Alpha Aero LLC · Saint Petersburg, FLBuilt 1962 · S/N 2256 N963KMMiller Karl E Trustee · Chandler, AZBuilt 1974 · S/N 17264198 N963RDBloxom Chase L · Josephine, TXBuilt 1993 · S/N JS001 N963RVRoberts Jim E · Portland, ORBuilt 1997 · S/N 001 N963WCCavorite Aviation LLC · Lehi, UTBuilt 2000 · S/N 2843381 N9640HCorriher Mark B · Mocksville, NCBuilt 1975 · S/N 17266287 N9640SFrancis James E · King City, CABuilt 1966 · S/N 6 N9640VN9640v LLC · Ann Arbor, MIS/N 17264420 N9641HBarton Alva L · Hollister, CABuilt 1975 · S/N 17266288 N9641JRegistration Pending · Fresno, CARegistration pendingS/N 28-3865 N9641KWempen Steven R · Assumption, ILBuilt 1976 · S/N 28-7615221

Back to AD 80-04-03 R2