Registered aircraft · 54,015

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.

N80985Mullins James C · Franklin, TNBuilt 1976 · S/N 17266826 N8098AGann Clifton T · Guthrie, OKBuilt 1952 · S/N 20950 N8098ERegistered aircraftN-number assigned, not yet registeredS/N 17272140 N8098LJordan James R Trustee · Hermon, MEBuilt 1967 · S/N 17256298 N8098XRaphael Christopher M · Colorado Springs, COBuilt 1961 · S/N 17248598 N80991Flowers Robert Clyde III · Manchaca, TXBuilt 1976 · S/N 17266830 N80996Halley Dan R · Avery, TXBuilt 1976 · S/N 17266832 N8099BKlosterman Aviation LLC · Celina, OHBuilt 1957 · S/N 29899 N8099LMateaki Koreen · Anchorage, AKS/N 17256299 N809BTLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1976 · S/N 17267437 N809STDiaz Natanael Luna · Toa Baja, PRS/N 17268873 N80AARegistered aircraftFirst renewal noticeBuilt 1964 · S/N 18051426 N80CAThomson Ian W · Anchorage, AKBuilt 1952 · S/N 20301 N80CRRdp Construction LLC · Sitka, AKBuilt 1980 · S/N U20605548 N80DLJetstream Aeronautics LLC · San Antonio, TXBuilt 1979 · S/N 15283230 N80FPCarastro Enterprises LLC · Montgomery, ALBuilt 1978 · S/N 17271343 N80GWSnyder Michael P · Las Vegas, NVBuilt 1974 · S/N 21060425 N80HXAthans Holdings LLC - Series 180 · Lake In The Hills, ILS/N 18053035 N80JWMorgan Philip H · Anchorage, AKBuilt 1961 · S/N 18051018 N80MTMeloche Michael S Trustee · Hamilton, MTBuilt 1979 · S/N U20605467 N80MWOlde North Church LLC · Wilmington, DEBuilt 1976 · S/N 18503092 N80NInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N P3370197 N80PPN80pp LLC · Titusville, FLBuilt 1966 · S/N 15064997 N80RXMccord Cheryl · Kuna, IDBuilt 1979 · S/N R1723276 N80SGFerland Henry L III · Vidalia, GABuilt 1980 · S/N 21064014 N80SMSkyward Aviation Enterprises LLC · Raleigh, NCS/N R172-0187 N80WCAir-Quip LLC · Boulder City, NVBuilt 1981 · S/N 18267838 N80WTOtter Creek Lodge LLC · Big Timber, MTBuilt 1976 · S/N 18052784 N8100SHigh Exposure Inc · Wilmington, DEBuilt 1965 · S/N 15061700 N8101LRegistration Pending · Minden, LARegistration pendingS/N 17256301 N8101UWeirick Kelly M · Morganton, NCBuilt 1964 · S/N 17252001 N8101XBreuer Elizabeth · Horseshoe Bend, IDBuilt 1961 · S/N 17248601 N8102ABuck Randall J · Greenfield, INFirst renewal noticeS/N 20954 N8102FFerrier Robert Clifford · Lindsay, CABuilt 1966 · S/N 15064202 N8102MShannon Michael E · Richland, WAS/N 18264540 N8102ZCrestview Estate LLC · Greenwood, SCBuilt 1962 · S/N 205-0102 N8103ACronk Kenneth B · Woodrow, COBuilt 1952 · S/N 20955 N8103BJafar Farid G · Pine Bluff, ARBuilt 1957 · S/N 29903 N8103LSoaring Mrt LLC · Lake Charles, LABuilt 1967 · S/N 17256303 N8103ZProsser Joel R · Sacramento, CABuilt 1962 · S/N 205-0103 N8104BRomar Mark A · Massillon, OHBuilt 1957 · S/N 29904 N8104FDunham John P · Colorado Springs, COS/N 15064204 N8104MMakati 121 LLC · Las Vegas, NVBuilt 1976 · S/N 18264541 N8104SFlowers Tony C · Panhandle, TXBuilt 1965 · S/N 15061704 N8104TBrewer Lance A · King Salmon, AKBuilt 1960 · S/N 17556804 N8104UMellen Dennis L · Peoria, ILBuilt 1964 · S/N 17252004 N8104ZNegris James R · Mazama, WABuilt 1962 · S/N 205-0104 N8105LIowa Skyhawk LLC · Charles City, IAS/N 17256305 N8105MSudworks Aviation LLC · Ardmore, OKBuilt 1976 · S/N 18264542 N8105TButcher Nicholas R · Litchfield Park, AZBuilt 1961 · S/N 56-805

Back to AD 87-20-03 R2