Registered aircraft · 54,019

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.

N2358URegistration Pending · Cave Creek, AZRegistration pendingBuilt 1962 · S/N 17249958 N2359FSheldon David E Trustee · Idaho Falls, IDBuilt 1964 · S/N 21058559 N2359RTide City Air LLC · Germantown, TNBuilt 1964 · S/N 18255459 N2359XHarker Charles R · Suwanee, GABuilt 1965 · S/N 18256259 N2359YWadsworth Edwin Allen · Sarasota, FLBuilt 1967 · S/N 17700159 N235AZSchlenker David D · Marine St Crx, MNBuilt 1980 · S/N R18201658 N235HLBeach Norman G Jr · Newman, CABuilt 1978 · S/N 18266526 N235NYCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274911 N235WJmzb Leasing LLC · Amarillo, TXBuilt 1979 · S/N 21063206 N235WHTail Aero Corp · Wilmington, DEBuilt 1977 · S/N 21061797 N2360CCkt Aviation LLC · Anchorage, AKBuilt 1953 · S/N 30660 N2360GVath Edward V · Acton, CABuilt 1958 · S/N 51660 N2361GMcmanigle Jeffrey M · Osakis, MNBuilt 1958 · S/N 51661 N2362RBarone Christian · Stratham, NHBuilt 1964 · S/N 18255462 N2362SMclaren Institute Of Transporation Technologies · Goode, VABuilt 1967 · S/N 337-0662 N2362XFort Scott Family Medicine Pa · Fort Scott, KSBuilt 1965 · S/N 18256262 N2363DCross John P · Houston, TXBuilt 1952 · S/N 20515 N2363FColumbus State Community College · Columbus, OHBuilt 1964 · S/N 21058563 N2363GSawaya Mark C · Spring Valley, CABuilt 1958 · S/N 51663 N2363RVertikle Enterprises LLC · Cheyenne, WYBuilt 1964 · S/N 18255463 N2363XShort Joe · Clintwood, VABuilt 1965 · S/N 18256263 N2363YPlane Pro Aviation LLC · Shelby, NCBuilt 1967 · S/N 17700163 N2364CMeinershagen Charles I · Redding, CABuilt 1953 · S/N 30664 N2364FCarlson David G Trustee · Cape Fair, MOBuilt 1964 · S/N 21058564 N2364GTveitnes Svein T · Whitewright, TXBuilt 1958 · S/N 51664 N2364RRegistered aircraftBuilt 1964 · S/N 18255464 N2364XElkhorn Aviation LLC · Norfolk, NEBuilt 1965 · S/N 18256264 N2365CStrolin LLC · Maple Valley, WABuilt 1978 · S/N R18200162 N2366CKase Gayle L · Wasilla, AKBuilt 1953 · S/N 30666 N2366DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 20518 N2366EWerner Service & Trucking Inc · Saint Edward, NEBuilt 1982 · S/N 18268197 N2366SDaughtrey Kevin E · Arcadia, FLS/N 337-0666 N2367DBushey Abel · Barnet, VTBuilt 1952 · S/N 20519 N2367GSahagun Salvador G · Bothell, WAS/N 51667 N2368UPlehn Thomas R · Las Vegas, NVBuilt 1962 · S/N 17249968 N2368XD C T LLC · Wallace, IDBuilt 1965 · S/N 18256268 N2369CBlackert Charles M · Delaware Water Gap, PABuilt 1954 · S/N 30669 N2369DAbbott Dylan L · Lompoc, CAS/N 20521 N2369GPeter Travis E · Casper, WYBuilt 1958 · S/N 51669 N2369UMahoney Brandon M · Laurelville, OHS/N 17249969 N2369YMischel John Patrick · Salyersville, KYBuilt 1967 · S/N 17700169 N236AMyotis Ltd · Leesburg, VABuilt 1973 · S/N 18262695 N236AFAero Fisheries Inc · Fort Pierce, FLBuilt 1976 · S/N 17267726 N236AGTroposphere Ventures LLC · Fond Du Lac, WIBuilt 1978 · S/N R18200788 N236DAFalany Curtis E · Tallahassee, FLBuilt 1966 · S/N 17254466 N236NYCivil Air Patrol Inc · Maxwell Afb, ALS/N 17268975 N236PTmg Investment Properties LLC · Surprise, AZS/N P21000116 N236RCCarter Rodney D · Artesia, NMBuilt 1983 · S/N R18201963 N2370DPoeppelman Philip W · Versailles, OHBuilt 1952 · S/N 20522 N2370GJ H Nicklas Inc · Cartersville, GABuilt 1958 · S/N 51670

Back to AD 87-20-03 R2