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.

N99750Kool Wings Leasing LLC · Indianapolis, INBuilt 1985 · S/N 17276504 N99759Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276506 N9975WPoole Terrell W · Rigby, IDBuilt 1967 · S/N 28-23523 N99765Tactical Intergriated Training Solutions LLC · Colorado Springs, COBuilt 1985 · S/N 17276507 N9976DHamon Troy R · King Salmon, AKBuilt 1959 · S/N 22-6767 N99770Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276508 N9977CSchuster Jacob M · Mchenry, ILBuilt 1972 · S/N 28-7225525 N9977DMesserla David M · Manhattan, KSBuilt 1959 · S/N 22-6768 N9977VLunceford James A · Stanchfield, MNBuilt 1974 · S/N 17264595 N9977WN9977w LLC · Easley, SCS/N 28-23525 N9977YBenninger Timothy A · Cobleskill, NYBuilt 1967 · S/N 18-8587 N99783Alexander Todd · Westhampton, MABuilt 1985 · S/N 17276510 N9978RButts James A · Gainesville, GABuilt 1960 · S/N TD-415 N997ABBentrup Reinhard F · Goleta, CABuilt 1993 · S/N 2377 N997CCWunorse Openslae LLC · Dallas, TXBuilt 2000 · S/N 9915CC N997NCVega Gustavo E · Watertown, NYBuilt 1965 · S/N 28-20817 N997SEAero Equities LLC · Ventura, CABuilt 1978 · S/N 17271571 N997SGRas Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7816562 N997UPPotti Noah · Kalispell, MTBuilt 1950 · S/N 20-246 N9980WAll American Aviation Services Inc · Fayetteville, NCBuilt 1967 · S/N 28-23528 N9981RMatthias Robert C · Gainesville, FLBuilt 1960 · S/N TD-419 N9981UExpedition Air LLC · Antioch, CABuilt 1977 · S/N AA5A0381 N9981VWeeks Richard F Jr · Portsmouth, NHFirst renewal noticeBuilt 1974 · S/N 17264599 N99826Cp Aviation · Santa Paula, CABuilt 1985 · S/N 17276514 N9983VHeyman William L · Santa Fe, NMBuilt 1974 · S/N 17264601 N9984RMoloney Phillip M · Lexington, KYS/N TD-420 N9984VValley Drug Of Malta Inc · Malta, MTBuilt 1974 · S/N 17264602 N9984WBlake David R · Sheridan, WYBuilt 1967 · S/N 28-23532 N9985BJacks Charles D · Morse, LABuilt 1982 · S/N 172RG1107 N9985DTrimmer Marvin E · Willow, AKBuilt 1959 · S/N 22-6777 N9986CLawrence Oakes K III · Newfields, NHS/N 241 N9986DWalsh Arthur B · Lincoln, NERegistration revokedBuilt 1959 · S/N 226778 N9986SKaneaster Richard W · Port Orange, FLBuilt 1996 · S/N 1218-96 N9988RSanders Flight Training Center Inc · Jasper, ALBuilt 1960 · S/N TD-407 N9988VLenoir Aviation Club Inc · Lenoir, NCFirst renewal noticeBuilt 1974 · S/N 17264606 N9988WHanneman Michael W · Abilene, TXBuilt 1968 · S/N 28-24838 N9989VPace Dusty · Pendleton, ORBuilt 1974 · S/N 17264607 N9989WDnr Solutions LLC · Idaho Falls, IDBuilt 1967 · S/N 28-23537 N998CCBecker Mike DBA · La Grande, ORBuilt 2000 · S/N 9916CC N998NCHoppe Joel A · Fort Myers, FLBuilt 1964 · S/N 250 N998RASchubert Brothers Aviation Inc · Canandaigua, NYBuilt 1973 · S/N 17261672 N998SEUtter Albert · Fort Myers, FLBuilt 1988 · S/N 17274025 N9990BAurora-Flight LLC · Commerce Township, MIBuilt 1982 · S/N 172RG1109 N9990CFogarty Stephen J · Wasilla, AKBuilt 1958 · S/N 245 N9990VCompass Aviation Inc · Shelby, NCBuilt 1974 · S/N 17264608 N99917Anderson Cody Jon · Orono, MEBuilt 1986 · S/N 17276527 N9991BTaft Leasing LLC · Bloomfield, NMBuilt 1982 · S/N 172RG1110 N9991DNothum Robert G · Dixon, MOBuilt 1959 · S/N 22-6783 N9991GSale Reported · Staten Island, NYSale reported, canceledBuilt 1979 · S/N 17273639 N9991VSafeway Flying Club Inc · Denmark, WIBuilt 1975 · S/N 17264609

Back to AD 80-04-03 R2