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.

N4922HOptic Air LLC · Maurice, IABuilt 1981 · S/N 18267853 N4922SNyrhinen Aki · Reno, NVBuilt 1980 · S/N R18201461 N4922VHhd Aviation LLC · Hamilton, OHBuilt 1973 · S/N 172RG0417 N4922YHowey Aviation LLC · Woodhaven, MIBuilt 1980 · S/N 21064047 N49230US Flight Academy International Inc DBA · Post, TXBuilt 1977 · S/N 15281205 N4923ADaniel Arthur D · Fishtail, MTBuilt 1956 · S/N 32320 N4923CSmith Justin K · Wasilla, AKBuilt 1975 · S/N 18502659 N4923DHarrier Aviation LLC · South Saint Paul, MNFirst renewal noticeBuilt 1979 · S/N 17272399 N4923UUnited Indian Missions Inc DBA · Tucson, AZS/N U20605164 N49249Krawczak Kyle C · Littleton, COBuilt 1979 · S/N 15283442 N4924AMachnik Todd J · Old Lyme, CTBuilt 1956 · S/N 32321 N4924DRobinson Anthony D · Brookshire, TXBuilt 1958 · S/N 51024 N4924ENorthstar E & C LLC · Anchorage, AKBuilt 1979 · S/N 18503909 N4924UScheren Raymond D · Johnson, VTBuilt 1965 · S/N 21058624 N4925CRichardson Richard E II · Windham, MEBuilt 1975 · S/N 18502660 N4925FA S Air LLC · Lantana, FLBuilt 1979 · S/N 17273103 N4925GSchwenker David W · Queensbury, NYBuilt 1979 · S/N 17273472 N4925KAlberts Nelson · Weatherford, TXBuilt 1979 · S/N P21000371 N49260Youth Aeronautics Education Foundation · Mattaponi, VABuilt 1977 · S/N 15281209 N49261Salem Oregon Flight Training LLC · Salem, ORBuilt 1977 · S/N 15281210 N49268Fox John E · Boonville, CABuilt 1977 · S/N 15281213 N4926AEngland John James · Montrose, COBuilt 1956 · S/N 32323 N49276Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281217 N4927BAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283709 N4927DGreenville Flight LLC · Greer, SCS/N 17272401 N4927NRmst LLC · Mason, OHBuilt 1979 · S/N 18267457 N4927QWakefield Aircraft LLC · Cooperstown, NDBuilt 1976 · S/N 18802662T N4927SDaniel L Voiers · Hephzibah, GABuilt 1980 · S/N R18201466 N4927UBetz Brett A · Reminderville, OHBuilt 1965 · S/N 21058627 N49285Fullerton Airport Pilot Association · Fullerton, CABuilt 1979 · S/N 15283445 N49288Wisconsin Aviation Inc · Watertown, WIBuilt 1977 · S/N 15281226 N4928BWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283710 N4928EAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17271676 N4928SJohnson Jeffrey S · El Dorado, CABuilt 1980 · S/N R18201467 N49292Johnson Scott W · Saline, MIS/N 15283446 N4929AApling Randall L · Wasilla, AKFirst renewal noticeBuilt 1954 · S/N 32326 N4929CBerry Darrel · Camden, TNBuilt 1959 · S/N 7803 N4929DUnion Flyers LLC · Union, SCBuilt 1958 · S/N 51029 N492SFSnohomish Flying Service Inc · Snohomish, WABuilt 1976 · S/N 17268310 N492WPAngel Aviation Inc · Peoria, AZBuilt 1979 · S/N 17272684 N4930ACapra Cory · Forest Lake, MNBuilt 1956 · S/N 32327 N4930BSkyranch Knoxville Youth Inc · Knoxville, TNS/N 15283712 N4930DToribio LLC · San Antonio, TXS/N 51030 N4930NOneill Aviation LLC · Lake Wales, FLBuilt 1977 · S/N 21062421 N4930RSouther Field Aviation Inc · Americus, GABuilt 1975 · S/N 18802447T N4931BWojtowicz Tomasz · Bronx, NYBuilt 1979 · S/N 15283713 N4931CEinstein Inc · Price, UTBuilt 1975 · S/N 18502662 N4931RRegistration Pending · Westhope, NDRegistration pendingBuilt 1975 · S/N 18802448T N49328Air Puerto Rico Corp · Aguadilla, PRFirst renewal noticeBuilt 1979 · S/N 15283448 N4932ALegas David S · Phoenix, AZBuilt 1956 · S/N 32329

Back to AD 87-20-03 R2