Registered aircraft · 54,016

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.

N1196YYork Aero Club Inc · York, SCBuilt 1962 · S/N 15059596 N11970Kiforishin Samuel · Westfield, MAS/N 15075748 N11971Registration Pending · Durham, NCRegistration pendingBuilt 1974 · S/N 15075749 N11974Yilmaz Enes A · Austin, TXBuilt 1974 · S/N 15075752 N1197FSchumacher Bradley M · Lewiston, IDBuilt 1975 · S/N 18502763 N1197MSholer Jon R · Battle Ground, WABuilt 1975 · S/N 18264241 N1197UP D H S Aerial Photography Inc · St Petersburg, FLBuilt 1976 · S/N 17266898 N1197VVentry Solutions Inc · Hauser, IDBuilt 1976 · S/N R1722137 N1198FStockle Barry W · Oakland, CABuilt 1966 · S/N 17254793 N1198MGoeke Christine A Trustee · Hartland, WIBuilt 1969 · S/N 17258698 N11995Russell Ricky · Montrose, ARS/N 18263974 N1199ULansford Inc · Clovis, NMBuilt 1982 · S/N 21064673 N119DCDuque Helen · Orlando, FLS/N 17267722 N119DHJohnson Peter L · Chico, CAS/N 36257 N119DSDeltasierra LLC · Staunton, VABuilt 1979 · S/N 18503735 N119FRJeffery & Weiss Holdings LLC · Long Beach, CAS/N 17276535 N119JLMayo Clive S · Palmetto Bay, FLBuilt 1973 · S/N 18262575 N119MSAeronorth LLC · Ann Arbor, MIBuilt 1969 · S/N 21059121 N119P4dw Interests LLC · Longview, TXS/N 17263873 N119RKHtv Music Co · Franklin, TNBuilt 1972 · S/N 18261574 N119WCSmith Steven W · Kodiak, AKBuilt 1972 · S/N 18052235 N11APAp Aero LLC · Oklahoma City, OKBuilt 1974 · S/N 21060168 N11ATChan Roger J · Anchorage, AKBuilt 1974 · S/N 18502547 N11BTBravo Tango LLC · Minden, LABuilt 1965 · S/N 18256146 N11CSilicz Nicholas J · Shafter, CABuilt 1975 · S/N 18502713 N11CEMelcher Pierre S · New Braunfels, TXBuilt 1974 · S/N 18502512 N11DHRegistered aircraftBuilt 1978 · S/N 18052974 N11DZLowe Jacob · Knoxville, TNBuilt 1965 · S/N 18256245 N11FJPetit Chris J · Marrero, LABuilt 1961 · S/N 18253252 N11FNScheck Christopher R · Troutdale, ORBuilt 1973 · S/N 15074423 N11FRMosley John E · Jackson, MSBuilt 1971 · S/N 18260761 N11FVInternational Aor Service Inc Trustee · Carson City, NVBuilt 1982 · S/N T303-00133 N11GSHuddleston Edward · Oaktown, INBuilt 1976 · S/N 15078597 N11HHRegistration Pending · Durango, CORegistration pendingBuilt 1965 · S/N 18051484 N11JESky Vista LLC · Macon, GABuilt 1974 · S/N 18263240 N11JJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000511 N11JTJjj Ventures LLC · Bronx, NYBuilt 1969 · S/N 15071181 N11KRDawson Gray N · Roseburg, ORBuilt 1976 · S/N 21061249 N11KTHilborn Rebecca M · Addison, NYBuilt 1956 · S/N 28593 N11LATwo-Ten LLC · Ramona, CABuilt 1968 · S/N 21059058 N11MBYoungstown Warren Development Partners · Youngstown, OHBuilt 1979 · S/N 17272769 N11NNLamm Russell N · Wernersville, PABuilt 1974 · S/N 17263954 N11PEAir Caribbean Inc · Dover, DES/N P3370322 N11RSager Timothy P · Tullahoma, TNBuilt 1952 · S/N 7765 N11TCShiver James B Jr · Stanley, NMBuilt 1977 · S/N 21062230 N11VBuckner Eldon L · Baker City, ORBuilt 1959 · S/N 55819 N11VYPritt Brian C · San Luis Obispo, CABuilt 1979 · S/N 18267086 N11WHT T Aero LLC · Pauls Valley, OKBuilt 1956 · S/N 33447 N11WSAviation Trust Company LLC · Oklahoma City, OKS/N P3370017 N11YJCrawley Frederick J · Virginia City, NVS/N 182-66498

Back to AD 87-20-03 R2