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.

N2860FSullivan Stanley D · South Jordan, UTBuilt 1966 · S/N 18256960 N2860KWolfe Don · Foresthill, CABuilt 1979 · S/N 18053102 N2860QLawton Metropolitan Area Airport Authority · Lawton, OKBuilt 1971 · S/N 17259860 N2860RStoddard Bruce R · Tucson, AZBuilt 1967 · S/N 18258460 N2861FProair LLC · Dayton, IDBuilt 1966 · S/N 18256961 N2861QBlackmon Robert · San Antonio, TXBuilt 1971 · S/N 17259861 N2861SEagley Ronald A · Anchorage, AKBuilt 1967 · S/N 15066761 N2862FFoxtrot Partners LLC · West Bountiful, UTBuilt 1966 · S/N 18256962 N2862RGuthrie Devin L · Sallisaw, OKBuilt 1967 · S/N 18258462 N2862SGrotbeck Carter L · Albuquerque, NMBuilt 1967 · S/N 15066762 N2862UWallace Jon W · Ozark, ARBuilt 1963 · S/N 17250462 N2862XMathews Nancy M · Englewood, TNS/N 17700262 N2862YDickson Troy S · Placerville, CABuilt 1962 · S/N 18253862 N2863ASkipper Jonathan H · Fayetteville, GABuilt 1953 · S/N 30063 N2863EWetherley Aviation LLC · Boise, IDBuilt 1978 · S/N 17271352 N2863FWright William J · Raeford, NCBuilt 1966 · S/N 18256963 N2863QSalsbery Randall E · Sharpsville, INBuilt 1971 · S/N 17259863 N2863YPiontek Claudia A · Henderson, NVBuilt 1962 · S/N 18253863 N2864CRegistration Pending · Bloomington, ILRegistration pending, pending cancellationBuilt 1954 · S/N 26407 N2864FPreszler Sharon J · Mesa, AZBuilt 1966 · S/N 18256964 N2864LTakle Management LLC · Bethany, OKS/N 17256064 N2864QEaglet Flight Operations Lp · Fort Worth, TXBuilt 1971 · S/N 17259864 N2864STop Aircraft Leasing LLC · Wilmington, DEBuilt 1967 · S/N 15066764 N2864XCardinal Airways LLC · St Johns, FLBuilt 1967 · S/N 17700264 N2865FMctaggart Briar · Oroville, CAS/N 18256965 N2865LIfr LLC · Springfield, MOBuilt 1967 · S/N 17256065 N2865QLasalle Charles H · Williamstown, NYBuilt 1971 · S/N 17259865 N2865YSinclair Maurice A · Melrose, IAFirst renewal noticeBuilt 1962 · S/N 18253865 N2866ATruman Sparks Aviation LLC · Snyder, TXBuilt 1953 · S/N 30066 N2866FHowell Thomas F · Red Bluff, CAS/N 18256966 N2866KDobransky Robert J · Peoria, AZBuilt 1979 · S/N 18053104 N2866LRegistration Pending · Spring Branch, TXRegistration pendingBuilt 1967 · S/N 17256066 N2866QAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1971 · S/N 17259866 N2866VLyles Ed · Newnan, GABuilt 1974 · S/N 15076304 N2866XFeller Gerald A · Long Beach, CAS/N 17700266 N2867CPlatt Ranch Inc · Kim, COBuilt 1954 · S/N 26410 N2867SJarrell Loyd F · Whitesburg, TNBuilt 1967 · S/N 15066767 N2867XThrush Air Lc · Mason City, IABuilt 1967 · S/N 17700267 N2867YCook Kevin M · Hallettsville, TXBuilt 1962 · S/N 18253867 N2868ATaylor Eric C · Port Townsend, WABuilt 1953 · S/N 30068 N2868CWhiteley David N · Graham, TXBuilt 1954 · S/N 26411 N2868FBrown Isabelle R · Bay Shore, NYBuilt 1966 · S/N 18256968 N2868KMyers Mark D · Anchorage, AKBuilt 1979 · S/N 18053105 N2868QRutherford Services Inc · Plains, PABuilt 1971 · S/N 17259868 N2869LHelmstetler John D · Mt Vernon, TXBuilt 1967 · S/N 17256069 N2869QDurnall Daniel J · Sonora, CABuilt 1971 · S/N 17259869 N2869RDiehl Steven L · Martinsburg, PABuilt 1967 · S/N 18258469 N2869UDavis Isabelle L · Mason, NHBuilt 1971 · S/N 18052216 N2869YDurand Russell Gene · Luthersville, GABuilt 1962 · S/N 18253869 N286TCJb Aviation LLC · Waxahachie, TXBuilt 1986 · S/N 21065001

Back to AD 87-20-03 R2