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.

N7214NThompson Jared N · Hayden, IDS/N 18263005 N7214TKennedy John M · San Leandro, CABuilt 1960 · S/N 46814 N7215EPatton James Jay · Sequim, WAS/N 52215 N7215QRhynette Airways LLC · Key Largo, FLBuilt 1972 · S/N 17260515 N7215SHitt Bruce A · North Augusta, SCBuilt 1967 · S/N 15067915 N7215TSmith Jon O · Leavenworth, WAFirst renewal noticeBuilt 1959 · S/N 46815 N7215XJackson Garrett J · Woodland, WABuilt 1961 · S/N 15059315 N72160Mccauley Thomas I · Puyallup, WAS/N U206-1303 N7216EZeus Air Inc · Wilmington, DES/N 52216 N7216GLincoln Skyways Inc · Lincoln, CABuilt 1969 · S/N 17258916 N7216MStanton Andrew J · Platte City, MOBuilt 1958 · S/N 55516 N7216QElias Close Deanna · Kenilworth, ILBuilt 1972 · S/N 17260516 N7216TRk Air LLC · Wilmington, DEBuilt 1959 · S/N 46816 N7216XAmann David P · Wesley Chapel, FLBuilt 1961 · S/N 15059316 N7217AMcguires Flying Service LLC · Obion, TNBuilt 1956 · S/N 29317 N7217ERomo Daryl · Anchorage, AKBuilt 1959 · S/N 52217 N7217GOne Niner Right LLC · Berkeley, CABuilt 1969 · S/N 17258917 N7217QRegistration Pending · Fond Du Lac, WIRegistration pendingS/N 17260517 N7217TDenney David W · Fowler, COS/N 46817 N7217XGorman Byron E · Knife River, MNBuilt 1961 · S/N 15059317 N7218AGurdak Paul J · Bristol, VTBuilt 1956 · S/N 29318 N7218ERice Ross H · Moab, UTBuilt 1959 · S/N 52218 N7218MFord Ethan G · Anchorage, AKS/N 55518 N7218TTwilley Reginald M · Mobile, ALFirst renewal noticeBuilt 1959 · S/N 46818 N72194Skydive Ky LLC · Cecilia, KYBuilt 1969 · S/N U206-1315 N7219MBrincefield Leland L · Waconia, MNBuilt 1958 · S/N 55519 N7219STulsa Flight Training LLC · Bixby, OKBuilt 1967 · S/N 15067919 N7219TScott Gregory R · Kennesaw, GABuilt 1959 · S/N 46819 N721AEmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 1978 · S/N 18266259 N721AAGammage Linda L · Delanco, NJBuilt 1968 · S/N 17257605 N721CWFischer Alfred M DBA · Genoa City, WIS/N 15067112 N721JMWalton Frederick W · Upper Sandusky, OHBuilt 1959 · S/N 56038 N721KCVan Brunt Paul A · East Bethel, MNBuilt 1977 · S/N R18200090 N721MWelch James D · Holdenville, OKBuilt 1957 · S/N 29879 N721NRUS Department Of The Interior · Boise, IDBuilt 1985 · S/N U20606902 N721SGAlaska Air Service LLC · Brookings, ORBuilt 1964 · S/N 206-0265 N7220GStagg Travis M · Fairbanks, AKBuilt 1969 · S/N 17258920 N7220NNatural Selection Farms Inc · Sunnyside, WABuilt 1974 · S/N 18263011 N7221EMuller Farm And Ranch · Grenora, NDBuilt 1959 · S/N 52221 N7221MStartin Evan A · Colfax, WABuilt 1958 · S/N 55521 N7221QSleeping Giant Flying Club · Helena, MTBuilt 1972 · S/N 17260521 N7221SGardner Riley F · Hamilton, TXBuilt 1976 · S/N 18265083 N7221TDahle Neil E · Mason City, IABuilt 1959 · S/N 46821 N72222Jouppi Kenneth J · Ward Cove, AKBuilt 1969 · S/N U206-1329 N7222AChamberlain C Douglas · Bellefontaine, OHBuilt 1956 · S/N 29322 N7222NN B Tweet & Sons · Nome, AKBuilt 1976 · S/N U20603568 N7222QMohawk Flying Club Inc · Ada, MIBuilt 1972 · S/N 17260522 N7222TRegistration Pending · Lawndale, CARegistration pendingBuilt 1959 · S/N 46822 N7223ASather Evan · Hayward, CAS/N 29323 N7223GLaze Daniel · Carson City, MIBuilt 1973 · S/N 15074624

Back to AD 87-20-03 R2