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.

N3942SCromley Amanda J · Lewisburg, PABuilt 1964 · S/N 17251142 N3942VMossman Andrew D · Pickerington, OHBuilt 1948 · S/N 18261 N3942YBender Andrew J · Greenwood Lake, NYS/N 21058442 N3943Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1984 · S/N 17276186 N3943DLoudan Christopher D · Trinidad, TXBuilt 1957 · S/N 34643 N3943VHardman Kyle B · Shady Shores, TXBuilt 1948 · S/N 18262 N3943YStuart Leslie Trustee · Roseburg, ORBuilt 1964 · S/N 21058443 N3944Avra Valley Flyers LLC · Gilbert, AZBuilt 1964 · S/N 17251510 N3944QFeauto Aviation Inc · Saint Cloud, FLBuilt 1971 · S/N 17260044 N3944RFedorko Stephen J · Springdale, ARBuilt 1966 · S/N 17255444 N3944YBrown Pelican Aviation LLC · Ralston, NEBuilt 1964 · S/N 21058444 N3945DBarnett Lance · Fairfield, CAS/N 34645 N3945LBlakesley Barrett · Spokane, WABuilt 1966 · S/N 17254114 N3945SStrickland Jason R · Tollhouse, CAS/N 17251145 N3946FMatson William J · Wasilla, AKBuilt 1958 · S/N 36846 N3946QSwihart Matthew · Hood River, ORBuilt 1973 · S/N 18502213 N3946SDepoy Lowell K · Salem, INBuilt 1964 · S/N 17251146 N3946YMorris Steven A · Houston, TXBuilt 1964 · S/N 21058446 N3947DBellew James W · Pueblo West, COBuilt 1957 · S/N 34647 N3947FStubbs Scott F · Tucson, AZBuilt 1958 · S/N 36847 N3947RCarter George T · Williamston, SCBuilt 1966 · S/N 17255447 N3947VCooper Charles N III · Sardinia, OHBuilt 1948 · S/N 18266 N3947YRafter Jm Enterprises LLC · Swink, OKBuilt 1964 · S/N 21058447 N3948QCitabria Inc · Auburn, CABuilt 1971 · S/N 17260048 N3948SDykstra Johnny R · Sioux Falls, SDBuilt 1964 · S/N 17251148 N3948UHolloway Earnie G · Bonner Springs, KSBuilt 1965 · S/N 15061348 N3948VKlein Jordan Jr · Summerfield, FLS/N 18267 N3948YSwine Management Service Inc · Long Island, KSBuilt 1964 · S/N 21058448 N3949FReed Systems Ltd · Ellenville, NYBuilt 1958 · S/N 36849 N3949QTuschen James E · Rockford, ILBuilt 1971 · S/N 17260049 N3949RLacroix Paul R · Taylor, MIBuilt 1966 · S/N 17255449 N3949SColler Sauntee C · Kadoka, SDBuilt 1964 · S/N 17251149 N3949VShort Thomas · Noblesville, INBuilt 1948 · S/N 18268 N394RAN Registration Service LLC Trustee · Sanford, NCS/N 21059329 N39501Registration Pending · Phoenix, AZRegistration pendingBuilt 1982 · S/N U206-06452 N3950FSeifert Justin R · Minot, NDBuilt 1958 · S/N 36850 N3950QDieter Jason W · Midlothian, VAS/N 17260050 N3950RJung Christopher M · Anchorage, AKS/N 47424 N3950SBlue Sky Aviation Adventures LLC · St George, UTS/N 17251150 N3950VPartridge Leslie R · Spicewood, TXS/N 18269 N3950YCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1964 · S/N 21058450 N3951JJenani Industries LLC · La Verne, CABuilt 1966 · S/N 15065251 N3951QGarcia Larry M · Garden Valley, CABuilt 1971 · S/N 17260051 N3951VBrosh Donald R · Centennial, COBuilt 1948 · S/N 18376 N3951YRodriguez Coppola Patricio Andres · New Orleans, LABuilt 1964 · S/N 21058451 N3952JStewarts Aircraft Service Inc · Waynesville, OHBuilt 1966 · S/N 15065252 N3952QLloyds 172 LLC · Moore, OKS/N 17260052 N3952STorres Jeremy · Cranston, RIBuilt 1964 · S/N 17251152 N3953FRegistration Pending · Plainfield, NJRegistration pendingBuilt 1958 · S/N 36853 N3953JKearns Reno T · Jeannette, PAS/N 15065253

Back to AD 87-20-03 R2