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.

N5448RBuby Lloyd F · Mannington, WVBuilt 1965 · S/N 17253001 N5448TRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1964 · S/N 17251348 N5449HMoorhead Aviation Services LLC · Moorhead, MNBuilt 1975 · S/N 17265445 N5449QHarper Randall W · Presque Isle, MEBuilt 1972 · S/N 15073349 N5449RMartin David · Waterport, NYBuilt 1965 · S/N 17253002 N544PZAdler Paul D · Chilmark, MABuilt 1973 · S/N 17701981 N544ZLeary Ken R · Fairbanks, AKBuilt 1971 · S/N 18052190 N545Providence Aerospace LLC · Choctaw, OKS/N 50001 N54502Ho Simpson S · Poway, CABuilt 1981 · S/N 17274991 N5450BKunz George M · Bakersfield, CABuilt 1956 · S/N 33450 N5450HLima-001 LLC · Muscatine, IABuilt 1975 · S/N 17265446 N5450QCruise Flight Academy Inc · Dalton, GABuilt 1981 · S/N 15285112 N5450RMayer Ag Service · Chamberlain, SDBuilt 1965 · S/N 17253003 N5451KSkywarior Flight Training Inc · Pensacola, FLBuilt 1980 · S/N 17274117 N5451NMiller Geoffrey J · Tucson, AZBuilt 1980 · S/N 18267724 N5451RYoungstown Warren Development Partners · Vienna, OHBuilt 1965 · S/N 17253005 N5451SDodson William G · Quebeck, TNBuilt 1966 · S/N 337-0551 N5451VParker James C · Cuthbert, GABuilt 1975 · S/N 21060952 N5452CMaas Barry M · Bothell, WABuilt 1950 · S/N 19486 N5452KAviation Club LLC · Sussex, NJBuilt 1980 · S/N 17274118 N5452QRhein Craig · Mastic, NYBuilt 1972 · S/N 15073352 N5452RWilliams Matthew W · Auburn, WABuilt 1965 · S/N 17253006 N5452TEagle Sky Patrol Inc · Deadwood, SDBuilt 1964 · S/N 17251352 N54531Jordan Alex N · Clarkton, NCBuilt 1981 · S/N 17274995 N5453BGoggans John L · Mansfield, MOS/N 33453 N5453CHead Laverne E · Ozark, ALBuilt 1950 · S/N 19487 N5453KDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 17274119 N5453MQueen City Flying Club LLC · Cincinnati, OHBuilt 1980 · S/N 15284590 N5453RVaughn Mark R · Fort Payne, ALBuilt 1965 · S/N 17253007 N5453TSale Reported · WeidenSale reportedBuilt 1982 · S/N R18201870 N5453VTim Whitfield Aviation Inc · Farfield, NCBuilt 1977 · S/N R1722299 N5454KGolden Mahalo LLC · Sheridan, WYBuilt 1980 · S/N 17274120 N5454NLeisure Flight LLC · Franklin, TNBuilt 1980 · S/N 18267725 N5454QPetko James · Mishawaka, INS/N 15073354 N5454TPearce David W Trustee · Anchorage, AKBuilt 1964 · S/N 17251354 N5455CSnurkowski John V · Laurens, NYBuilt 1950 · S/N 19489 N5455HMiller Michael R · Portage, MIBuilt 1975 · S/N 17265449 N5455JFriend John M · Ozawkie, KSBuilt 1980 · S/N 17273801 N5455NPage Michael C Trustee · Stuart, FLBuilt 1980 · S/N 18267726 N5455REpstein Paul · Pensacola, FLBuilt 1965 · S/N 17253010 N5455TStrickland Justin Ryan · Lovington, NMBuilt 1964 · S/N 17251355 N54569Buehler Thomas M · Renton, WABuilt 1981 · S/N 17275002 N5456EKais Air LLC · Terre Haute, INBuilt 1983 · S/N 18268323 N5456NBazar Paula · Woodland Hills, CABuilt 1980 · S/N 18267727 N5456SWood Charles G Trustee · Amarillo, TXBuilt 1967 · S/N 337-0556 N5456TKelley Keith B · Forney, TXBuilt 1964 · S/N 17251356 N5456YWings As Eagles LLC · Wilmington, DES/N 21064211 N54572Perry Dennis T · Seward, AKS/N 18052256 N54576Rick Aviation Inc · Newport News, VAS/N 17275003 N5457AGoebel Joseph · Palos Verdes Est, CABuilt 1985 · S/N P21000856

Back to AD 87-20-03 R2