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.

N3882GRanier Flight Service LLC · Friday Harbor, WABuilt 1967 · S/N U206-0882 N3882JPeek James · South Fork, COBuilt 1966 · S/N 15065182 N3882QRiddle Kenneth G · Cherryville, NCBuilt 1971 · S/N 17259982 N3882SNichols Troy · Clinton, ARBuilt 1963 · S/N 17251082 N3883LBragg Gary W · Rainelle, WVBuilt 1966 · S/N 17254052 N3883QAir Williams LLC · Arlington, TXBuilt 1971 · S/N 17259983 N3883RGingras Carl A · Avondale, COBuilt 1966 · S/N 17255383 N3883SBruns Scott A · Brodhead, WIBuilt 1964 · S/N 17251083 N3884DBryant Melvin Barry · Cascade, IDBuilt 1957 · S/N 34584 N3884LCosta Jason L · Spring Hill, FLBuilt 1966 · S/N 17254053 N3884QWrangell Mountain Air Inc · Palmer, AKBuilt 1971 · S/N 17259984 N3884SHawley Michael C · Hampton, NHBuilt 1963 · S/N 17251084 N3884VMather Todd A · Huron, OHBuilt 1949 · S/N 7353 N3885QGades Allen L Trustee · Montevideo, MNBuilt 1973 · S/N 18502207 N3885SLewis Kyle P · Shelbyville, KYBuilt 1964 · S/N 17251085 N3886DHarper Shawn W · Bayfield, COBuilt 1957 · S/N 34586 N3886LRench Eugene G · Owosso, MIS/N 17254055 N3886PUncanny Valley Films Inc · Arroyo Seco, NMBuilt 1978 · S/N P21000068 N3887DWin Win Aviation Inc · Wake Forest, NCBuilt 1957 · S/N 34587 N3887LHigley Ryan · Arlee, MTBuilt 1965 · S/N 17254056 N3888CBoyce Clayton · Lake Village, INBuilt 1954 · S/N 31036 N3888DAviation Of North Florida LLC · Jacksonville, FLBuilt 1957 · S/N 34588 N3888JAzalea Aviation LLC · Quitman, GABuilt 1966 · S/N 15065188 N3888RGriswold Zachary S · Waunakee, WIBuilt 1966 · S/N 17255388 N3888YDodson Timothy A · Tulare, CABuilt 1964 · S/N 21058388 N3889JVeduccio Gary Robert · Griffin, GABuilt 1966 · S/N 15065189 N3889LBaker Duane · Shepherd, TXS/N 17254058 N3889QRegistration Pending · White, GARegistration pendingBuilt 1971 · S/N 17259989 N3889RAdams Donald C · Garner, NCBuilt 1966 · S/N 17255389 N388AGGlenn Alan K · Winnie, TXBuilt 1969 · S/N 18260122 N388JFAspire Aviation LLC · Farmingdale, NYS/N 17276182 N388LCIshawooa Air LLC · Cody, WYBuilt 1965 · S/N 18256441 N388PGAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17260525 N388SStarr William E · Eagle River, AKBuilt 1984 · S/N U20606838 N388SESunset Eagle Aviation LLC · Southport, FLBuilt 1968 · S/N 15068466 N388TCDopson Joel A · Ooltewah, TNBuilt 1956 · S/N 29601 N388WAuza Joseph · Casa Grande, AZBuilt 1956 · S/N 33876 N389Donalds Flying Service Inc · Pantego, NCBuilt 1953 · S/N 30085 N3890CBrandt Robert C · Schaumburg, ILBuilt 1954 · S/N 31038 N3890LTexas Yellow Rose Planes LLC · Fort Worth, TXBuilt 1965 · S/N 17254059 N3890RWright Chad · Fredericktown, OHBuilt 1966 · S/N 17255390 N3890VInternational Air Services Inc Trustee · Carson City, NVBuilt 1949 · S/N 7361 N3890YEllsworth Joseph D Trustee · Salida, COBuilt 1964 · S/N 21058390 N3891CStaple K Aviation LLC · Queen Creek, AZBuilt 1954 · S/N 31039 N3891GTangent Aviation LLC · Oro Valley, AZBuilt 1967 · S/N U206-0891 N3891QRiley George L III · Washington, INBuilt 1971 · S/N 17259991 N3891RN3891r LLC · Ogden, IAS/N 17255391 N3891VKilo Aviation LLC · East Peoria, ILFirst renewal noticeBuilt 1949 · S/N 7362 N3891YCartwright Chris · Yuba City, CABuilt 1964 · S/N 21058391 N3892DWeiss Steven John · Las Vegas, NVBuilt 1957 · S/N 34592

Back to AD 87-20-03 R2