Registered aircraft · 54,017

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.

N3581FSkyline Aviation Services LLC · Miramar, FLBuilt 1973 · S/N A1500413 N3581QQuantie Harold G · Locust Grove, OKBuilt 1973 · S/N 17261681 N35821Coachair Inc · Groveland, CABuilt 1976 · S/N 177RG1056 N3582CBenedict Larry D · Dexter, NMBuilt 1955 · S/N 26626 N3582DFrench Guy · Maple Valley, WABuilt 1956 · S/N 27125 N3582JMorris Jon · Thatcher, AZBuilt 1965 · S/N 15061282 N3582SMcmath Albert J Jr · Onley, VABuilt 1963 · S/N 17250782 N3582UMorton Construction Inc · Stillwater, OKBuilt 1963 · S/N 18254982 N3582YErkens Ronald B · Queen Creek, AZBuilt 1963 · S/N 18254482 N35833Williams David Wayne · Ivins, UTBuilt 1976 · S/N 177RG1057 N35837Smernoff Michael J · Des Plaines, ILBuilt 1975 · S/N U20602749 N3583JVali Air Service LLC · Livingston, MTBuilt 1965 · S/N 15061283 N3583SWalls Jerry L · Hawley, TXBuilt 1963 · S/N 17250783 N3583YCollins Carl H · Longview, TXBuilt 1962 · S/N 18254483 N35849Gilliam Robert L · Islamorada, FLBuilt 1976 · S/N 177RG1060 N3584CSnyder Kathryn J · Sutherland, NEBuilt 1955 · S/N 26628 N3584LKlesser Zachary S · Coronado, CABuilt 1965 · S/N 15062384 N3584SPaul Aviation LLC · Wasco, CABuilt 1963 · S/N 17250784 N3584UMagic Valley Aero Club Inc · Twin Falls, IDBuilt 1963 · S/N 18254984 N3584VMurdoch Bryan · Lantana, FLBuilt 1975 · S/N 15076553 N3584YHassler John Cameron · East Helena, MTBuilt 1962 · S/N 18254484 N35850Willke Ronald S · Edgewood, TXBuilt 1976 · S/N 177RG1061 N35851Northwest Passage LLC · Anchorage, AKS/N U20602757 N35852Taylor Bruce D · Cedar Rapids, IAFirst renewal noticeS/N 177RG1062 N35858Watkins Rickar D · Roseburg, ORBuilt 1976 · S/N 177RG1063 N35859Hooper Ranch LLC · Elko, NVBuilt 1975 · S/N U20602763 N3585CRachels Paul R · Tacna, AZBuilt 1955 · S/N 26629 N3585FArikara Properties LLC · Beulah, NDBuilt 1966 · S/N 18257585 N3585QLerner Daniel A · East Durham, NYBuilt 1973 · S/N 17261685 N3585SNorman Jon D · Plainwell, MIBuilt 1963 · S/N 17250785 N3585UNieder Brady W · Anchorage, AKBuilt 1963 · S/N 18254985 N3585YSeemann Brian N · Lake Havasu City, AZBuilt 1963 · S/N 18254485 N35866Terry Kayla · Moulton, ALBuilt 1976 · S/N 177RG1065 N35868Spence Flight Service LLC · Enterprise, ORBuilt 1973 · S/N U20602107 N35869Cardinal Flyers LLC · Moriches, NYBuilt 1976 · S/N 177RG1067 N3586FRegistration Pending · Phoenix, AZRegistration pendingBuilt 1966 · S/N 18257586 N35872Kurtz David Lee · Cordele, GABuilt 1976 · S/N 177RG1068 N35877Turbine Conversions Ltd · Nunica, MIBuilt 1975 · S/N U20602777 N35879Aldrich Brad · Driftwood, TXBuilt 1976 · S/N 177RG1069 N3587FStout Colt W · Bosque Farms, NMBuilt 1966 · S/N 18257587 N3587JJacobson Austin G · Los Alamos, NMBuilt 1965 · S/N 15061287 N3587QBerger Donald D · Ilwaco, WABuilt 1973 · S/N 17261687 N3587SRegistered aircraftAssigned, pending cancellationS/N 17250787 N35883Sasquatch Alaska Adventure Co LLC · Fritz Creek, AKBuilt 1975 · S/N U20602779 N35884Dake Tech Consulting Inc · San Dimas, CAS/N 177RG1070 N35889Torgerson Management Inc · Turtle Lake, WIBuilt 1975 · S/N U20602783 N3588FBlue Eagle Aviation LLC · Edmond, OKS/N 18257588 N3588LVandegrift David H · St Paul, MNBuilt 1965 · S/N 15062388 N3588UBattles Danny C · Burns Flat, OKBuilt 1963 · S/N 18254988 N3589CPalmer Frederick W · Huntington Beach, CABuilt 1954 · S/N 26633

Back to AD 87-20-03 R2