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.

N9641QBhairavi Aviation LLC · Santa Clarita, CABuilt 1975 · S/N 17265725 N9641UHunt David C · Middlebury, CTBuilt 1975 · S/N AA5A-0007 N9641VRink Douglas B · Woolwich, MEBuilt 1974 · S/N 17264421 N9641WHoover Anna L · Anchorage, AKBuilt 1967 · S/N 28-23100 N9642CBarts Flying Service Inc · Storm Lake, IABuilt 1978 · S/N 28-7816509 N9642DMalsom Isaac B · Box Elder, SDBuilt 1959 · S/N 22-6556 N9642JSafety First Flying · Murphysboro, ILS/N 28-3870 N9642RAvian Flight Center Inc · Bremerton, WABuilt 1959 · S/N TD-328 N9642STaylor Jonathan K II · Granbury, TXBuilt 1966 · S/N 3 N9642WN9642w Leasing LLC · Corunna, MIBuilt 1967 · S/N 28-23101 N9643DBlumhorst Ricky W · Paola, KSBuilt 1959 · S/N 22-6557 N9643HMor Aviation N9643h LLC · Gaithersburg, MDBuilt 1975 · S/N 17266290 N9643JHitchings Fred · Chesapeake, OHBuilt 1967 · S/N 28-3871 N9643QLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 17265727 N9643STurner Nathan D · Nenana, AKFirst renewal noticeBuilt 1966 · S/N 20 N9643VBrazos Valley Flight Services LLC · College Station, TXBuilt 1974 · S/N 17264423 N9643WN9643w LLC · Dover, DEBuilt 1967 · S/N 28-23102 N9644CBybee John E · Burlington, IABuilt 1967 · S/N 089 N9644JLeckliter Michael A · Murrieta, CABuilt 1966 · S/N 28-3808 N9644QSkyhawks Inc · Chippewa Falls, WIBuilt 1975 · S/N 17265728 N9645DDarryn Allyson R · Las Cruces, NMBuilt 1959 · S/N 22-6559 N9645HSantiago Diana L · Juana Diaz, PRBuilt 1975 · S/N 17266292 N9645JLuxury Vacations Inc · Scottsdale, AZBuilt 1966 · S/N 28-3809 N9645VOak Ridge Flyers Inc · Oak Ridge, TNBuilt 1974 · S/N 17264425 N9646BN9646b LLC · Wilmington, DEBuilt 1981 · S/N 172RG0942 N9646DFerrell Alan B · Arlington, OHBuilt 1959 · S/N 22-6560 N9646RB-Dog Aviation LLC · Grand Junction, COS/N TD-345 N9646WOgier Gerard Paul · Hampton, NHBuilt 1967 · S/N 28-23105 N9647BLakewood Investments LLC · Victorville, CAS/N 172RG0943 N9647DSutton Neal · Ashby, NEBuilt 1959 · S/N 22-6561 N9647QKaeni Law Group Inc · Santa Ana, CABuilt 1975 · S/N 17265731 N9647UWilhite Randall D · Plainville, MABuilt 1975 · S/N AA5A-0013 N9647WAirplanes Plus Inc · Marathon, FLBuilt 1967 · S/N 28-23106 N9648HSaunders Larry F · Sulphur Springs, ARBuilt 1975 · S/N 17266294 N9648MN9648m LLC · Louisville, KYBuilt 1967 · S/N 670225 N9648QGreen Bay Flying Club Inc · Krakow, WIBuilt 1975 · S/N 17265732 N9648VGrove Kaylene · San Diego, CABuilt 1974 · S/N 17264428 N9648WMccullough Dwayne D · Onancock, VABuilt 1967 · S/N 28-23107 N96493Smtm Holdings Inc · Wilmington, DES/N 17276080 N9649BGoebel Christian E · Luray, VABuilt 1981 · S/N 172RG0945 N9649DUlrich Kenneth B Jr · Kingwood, TXBuilt 1959 · S/N 22-6563 N9649JRegistration Pending · Springboro, OHRegistration pendingBuilt 1967 · S/N 28-3876 N9649VLagorce Victor X · Owasso, OKBuilt 1974 · S/N 17264429 N9649WWard Travis E · Tucson, AZBuilt 1967 · S/N 28-23109 N964AAFlorida Flight Training Center Inc · Venice, FLBuilt 1978 · S/N 17271084 N964HLGraham Huber L · Gulf Breeze, FLBuilt 2001 · S/N 1 N964SHI1 Aviation LLC · Wilmington, DEBuilt 2005 · S/N 3941 N964TEBedard Robert L · Bolivar, OHBuilt 2005 · S/N 10243 N96503Miravete Paul Trustee · Saint George, UTBuilt 1983 · S/N 17276081 N9650DKahanek Doug II · Alvarado, TXBuilt 1959 · S/N 22-6564

Back to AD 80-04-03 R2