Registered aircraft · 54,019

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N1790RBlack Dog Holding Inc · Pleasant Valley, NYS/N 18502506 N1791MA & S Helicopters Inc · Cahokia, ILBuilt 1971 · S/N 33701391 N1791QNearpass Stephen J · Seneca Falls, NYS/N 15073091 N1791VOmargows Ali · Columbus, OHBuilt 1974 · S/N 17263752 N1792REcho Matrix LLC · Bentonville, ARBuilt 1974 · S/N 18502508 N1793DThompson Joshua L · Delta Junction, AKBuilt 1951 · S/N 20235 N1793QFreedom Aviation Inc · Lynchburg, VABuilt 1971 · S/N 15073093 N1793VAviation Capital Management LLC · San Jose, CABuilt 1974 · S/N 17263753 N1794CAcp Aviation LLC · Oakdale, LABuilt 1953 · S/N 30494 N1794MSkyriders Flying Club Inc · Aurora, COBuilt 1975 · S/N 18264447 N1794XGulf Atlantic Airways Inc · Gainesville, FLBuilt 1975 · S/N 21060814 N1795CSchellhaas Bennett · Galloway, OHBuilt 1953 · S/N 30495 N1795RBroussard Kenneth John · Lafayette, LABuilt 1974 · S/N 18502511 N1796DRacoon Aviation LLC · San Antonio, TXBuilt 1951 · S/N 20238 N1797CKelley Larry D · Portland, ORBuilt 1953 · S/N 30497 N1797DBb Tacos And More Inc · Kalispell, MTBuilt 1951 · S/N 20239 N1797MCp & R Transport LLC · Grace, IDBuilt 1975 · S/N 18264450 N1797RNorthstar Holdings LLC · Anchorage, AKBuilt 1981 · S/N U20606331 N1797XN1797x Aero LLC · Gulf Breeze, FLBuilt 1975 · S/N 21060817 N1797ZReal Fly Air Service LLC · Jackson, WYBuilt 1963 · S/N 336-0097 N1798MWalker Steven C · Lake Havasu City, AZBuilt 1975 · S/N 18264451 N1798RSedwick Jack D III · Anchorage, AKBuilt 1974 · S/N 18502514 N1798XN1798x LLC · Etna Green, INBuilt 1975 · S/N 21060818 N1799RAir Support 1 Inc · Middletown, DEBuilt 1974 · S/N 18502515 N1799ZWanderlove Alaska LLC · Anchorage, AKBuilt 1963 · S/N 336-0099 N179DBBrisco Daniel J · Fort Myers, FLS/N 15075498 N179MMDe Schweinitz Christian R · Anchorage, AKS/N 19423 N179WSEbken Gary R · Loxahatchee, FLBuilt 1959 · S/N 51698 N179WZCatterton Jane S · Signal Mountain, TNBuilt 1981 · S/N 18268036 N179XPLadonne Frank · Fort Collins, COBuilt 1979 · S/N R1723155 N17ABBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 21057674 N17BHFoster Brian J · Mancelona, MIBuilt 1972 · S/N 18261384 N17BSSell William T · Orofino, IDBuilt 1965 · S/N 17252856 N17CJ16d Aviation LLC · Vashon, WABuilt 1968 · S/N U206-1199 N17DMLevin Jason Daniel · Aptos, CABuilt 1973 · S/N 177RG0420 N17FCUsda Forest Service Fepp · Columbia, SCBuilt 1970 · S/N 18260269 N17FGWard Bruce L · Key West, FLBuilt 1976 · S/N 15077906 N17GNGrant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 20700693 N17HSRed Oak Centurion LLC · Red Oak, IABuilt 1967 · S/N 21058844 N17HZLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 172-66345 N17JYYorkavitz James B · Valley City, OHBuilt 1969 · S/N 21059154 N17MMBekanich Jason · Camden, NCBuilt 1967 · S/N 18258323 N17NFBravo Hotel LLC · Lewes, DES/N P206-0369 N17NJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274527 N17RRRiverside Flight Center Inc · Tulsa, OKBuilt 1979 · S/N 15284134 N17SMN17sm LLC · Coral Springs, FLS/N 17272967 N17SRNcsb LLC · Anchorage, AKBuilt 1974 · S/N 18502424 N17TBarney Julius C · Lutz, FLBuilt 1968 · S/N 337-0990 N17TBOwen Bertha C · Port Saint Lucie, FLBuilt 1955 · S/N 27067 N17TCKenyon Walter C · Eureka Springs, ARBuilt 1964 · S/N 21058499

Back to AD 87-20-03 R2