Registered aircraft · 40,472

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.

N371DSCl Finney Aviation LLC · Benton, KSBuilt 1955 · S/N 23-153 N371FZMerkan Michael B · Waterloo, ILBuilt 1989 · S/N 371 N371LSatellite Flying Club Inc · East Patchogue, NYBuilt 1970 · S/N 17701488 N371SAJoshua Leo · Midway, GABuilt 1966 · S/N 28-22550 N371SCCaracciolo Tristano · Dayton, NVBuilt 1970 · S/N 18-8914 N3720XDake Matthew D · Rome, GAS/N 5025 N3722MRegistration Pending · Bulverde, TXRegistration pendingS/N 28-7890326 N37240Green Clarence L · Hondo, TXBuilt 1980 · S/N M-2282 N3724BFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1980 · S/N ME349 N3724HAviation Capital Management LLC · San Jose, CABuilt 1982 · S/N ME-350 N3724KTreharne Russell C · Fruita, COBuilt 1967 · S/N 28-23703 N3724MRegistration Pending · Greenville, SCRegistration pendingBuilt 1978 · S/N 28-7890327 N3724XJefferies Vincent B · Rock Springs, WYBuilt 1968 · S/N 5030 N3725PEnck Ronald L · Corvallis, ORBuilt 1955 · S/N 22-3443 N3725RSoutheastern Business Machines Inc · Baxley, GABuilt 1970 · S/N 28-5810 N3726NVilvens Justin T · Granville, OHBuilt 1968 · S/N 680051 N3726PPrimm Jim R · Roswell, NMBuilt 1955 · S/N 22-3444 N3727XBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 5033 N3728GDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N ME-357 N3728KDunham Christopher B · Atlanta, GABuilt 1980 · S/N M-2285 N3728PChambers Clark B · Wichita, KSBuilt 1955 · S/N 22-3446 N3728XNimmo Andrew J · Childress, TXBuilt 1968 · S/N 5035 N3729MArnold Ray E · Cascade, IDBuilt 1947 · S/N 12-2669 N372GGIal Corp · Lewes, DEBuilt 1981 · S/N 17274926 N372SAJoe Wagner IV Construction LLC · Zebulon, NCBuilt 1979 · S/N 17272854 N372TBeautte James E · Fairland, OKBuilt 1948 · S/N 14-492 N3730HFox Valley Aero Club Inc · Oshkosh, WIBuilt 1980 · S/N M-2287 N3730KCloutier Felix S · Fond Du Lac, WIBuilt 1967 · S/N 28-23708 N3731DMond Darcee · Galena, ILS/N 17267 N37321Hamilton Janet S · Townsend, GABuilt 1980 · S/N M-2288 N3732PHusain Arif · Pipersville, PABuilt 1955 · S/N 22-3451 N3733DSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1980 · S/N ME-362 N3733GPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1980 · S/N ME-364 N3733PCottrell Mark C · Leitchfield, KYS/N 22-3453 N3734PHamilton Richard L · Monticello, FLBuilt 1955 · S/N 22-3454 N3734UDaricl LLC · Shoreham, NYBuilt 1980 · S/N M-2290 N3734XTechnical Education Services Inc · Virginia Beach, VABuilt 1968 · S/N 5042 N3735XMcmanus Edwin · Austin, TXS/N 5043 N3736KBloom Cory G · Indianola, IABuilt 1967 · S/N 28-23713 N3736PKelly Larry M · Alexander City, ALBuilt 1955 · S/N 22-3456 N3736XSmith William C · San Antonio, TXBuilt 1968 · S/N 5045 N3737UAirria Holdings LLC · BerlinBuilt 1980 · S/N ME-379 N3739QN3739q LLC · Colleyville, TXFirst renewal noticeBuilt 1982 · S/N ME-378 N373BSPenn Mitchell · Poplar Bluff, MOBuilt 1969 · S/N 28-26555 N373EWBaker Sheryl Wolff · Elbert, COS/N 80476 N3740XBarnato Peter M · Twain Harte, CABuilt 1968 · S/N 5050 N3741APrice John C · Bennington, KSBuilt 1953 · S/N 22-1984 N3741ZStanton Morgan · Anchorage, AKBuilt 1963 · S/N 18-7497 N3742XHancock John R · Poplarville, MSBuilt 1968 · S/N 5052 N3743PBulldog Aviation LLC · Ely, MNBuilt 1955 · S/N 22-3463

Back to AD 80-04-03 R2