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.

N6228RMangham Charles H · Mineral Wells, TXBuilt 1965 · S/N 15061528 N6228SYoder Edwin A Jr · Concord, GAS/N 15067028 N62296Sale Reported · Signal Hill, CASale reportedS/N 17275249 N6229ABrown Jennifer L · Vancouver, WAS/N 33029 N6229CClause James W Trustee · La Quinta, CABuilt 1979 · S/N 21063838 N6229EBidus Brent E · Sandpoint, IDBuilt 1983 · S/N 18268353 N6229FGav Air Capital LLC · Trophy Club, TXBuilt 1975 · S/N 18264133 N6229NTran Daniel T · Aliso Viejo, CABuilt 1980 · S/N 18267805 N622APCaradine Jimmie · Commerce, TXFirst renewal noticeBuilt 1969 · S/N 15071086 N622DCCarter Aviation LLC · Denver, COBuilt 1977 · S/N 18503465 N622DLColorado Aircraft Corp · Watkins, COBuilt 1975 · S/N 17264853 N622EHaggerty Russell P · Bethpage, NYBuilt 1971 · S/N 17260059 N622FEPeninsula Aero Technology Inc · Kenai, AKBuilt 1971 · S/N 18260805 N622GPTwenty Two Ashford LLC · Brentwood, TNBuilt 1981 · S/N 17274593 N622RFFrench Robert S · Sunnyvale, CABuilt 1978 · S/N 15282769 N6230Cavanaugh Paul R · Plantsville, CTS/N 15071630 N6230DUsda Aphis Wildlife Services · Cedar City, UTBuilt 1979 · S/N 17272648 N6230EDean Matthew · Pine Grove, CAS/N 46330 N6230QEast Hill Flying Club Inc · Ithaca, NYBuilt 1981 · S/N 15285205 N6230SMelnyk Oleg · Willoughby Hills, OHBuilt 1967 · S/N 15067030 N6231EMiller Edward P · Northfield, MNBuilt 1978 · S/N 17272001 N6231FH & F Aviation Inc · Labelle, FLS/N 17273170 N6231RSando Mark T · Carson City, NVBuilt 1965 · S/N 15061531 N6232APeters Duane A · Anchorage, AKBuilt 1956 · S/N 33032 N6232DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272650 N6232RBeavers Benjamin K · Omaha, NEBuilt 1965 · S/N 15061532 N6232TDavenport Richard B · Danbury, TXBuilt 1964 · S/N 15060932 N62332Skylens LLC · Hammond, LABuilt 1981 · S/N 17275251 N6233AAgl Aero LLC · Mckinney, TXS/N 33033 N6233DGrauert Ritter Trustee · Van Nuys, CAS/N 17272651 N6233FBach Haley Rayna · Sedona, AZS/N 18264135 N6233S33sierra LLC · Soldotna, AKBuilt 1967 · S/N 15067033 N6233ZMission Aviation Fellowship · Nampa, IDBuilt 1981 · S/N U20606195 N62348Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275254 N6234ALiu Weston B · Brookline, NHBuilt 1956 · S/N 33034 N6234RFly Big Sky LLC · Missoula, MTS/N 15061534 N6234SCorbin M Stuller · Yoder, INBuilt 1967 · S/N 15067034 N62350Flycarolina LLC · Concord, NCBuilt 1981 · S/N 17275255 N62354Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275256 N6235AStewart Madison F Co Personal Representative · Broken Arrow, OKS/N 33035 N6235ELee William Lewis · Gilbert, AZS/N 46335 N6235KCall One Inc · Clarinda, IABuilt 1975 · S/N 15077602 N6235SRudnik Zachary A · Minto, NDBuilt 1967 · S/N 15067035 N6237ESale Reported · Brandon, MSSale reportedS/N 46337 N6237FPerea Joseph R · Albuquerque, NMBuilt 1975 · S/N 18264139 N6237RBorden Jonathan Wilfred · Londonderry, NHS/N 15061537 N6237YStrategic Sourcing Solutions Inc · Topeka, KSBuilt 1981 · S/N 21064303 N6238RRegistration Pending · Preston, IDRegistration pendingBuilt 1965 · S/N 15061538 N6238TLocklear Benjamin M · Mangum, OKBuilt 1964 · S/N 15060938 N6238UInland Crop Dusters Inc · Shafter, CABuilt 1979 · S/N U20605393

Back to AD 87-20-03 R2