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.

N6796HAmelia Reid Aviation LLC · San Jose, CABuilt 1975 · S/N 17265584 N6796SRegistration Pending · Lawrence, KSRegistration pendingS/N 15067596 N67973Wings Over Texas Holding LLC · Denton, TXBuilt 1978 · S/N 15282121 N6797EJoe Bob Nelson · Chickasha, OKBuilt 1978 · S/N 17272069 N6797FGriswold M Dallas · Cordele, GABuilt 1966 · S/N 15063397 N6797MAim East Bay Aviation LLC · Danville, CABuilt 1975 · S/N 18263841 N6797RJts Management Inc · Lincoln, NEBuilt 1966 · S/N T210-0197 N6798GCowan Ronnie C · Glasgow, KYS/N 15072298 N6798HWnk Leasing LLC · Lewes, DEBuilt 1975 · S/N 17265586 N67991Rainier Flight Service LLC · Renton, WABuilt 1978 · S/N 15282124 N67993Johnson Joshua S · Lake Jackson, TXBuilt 1978 · S/N 15282126 N67995New Horizon Aviation Inc · Warwick, RIBuilt 1978 · S/N 15282128 N6799GWetzler Brian · Bainbridge Island, WABuilt 1970 · S/N 15072299 N6799MCoop Aero LLC · New Albany, MSBuilt 1975 · S/N 18263843 N6799SAdr Aircraft Service Inc · Burbank, CABuilt 1967 · S/N 15067599 N679DLBlink Squirrel Aviation LLC · Cherokee, IABuilt 1970 · S/N 17259138 N679JTAdventure Aviation Sales Inc · Jeffersonville, INBuilt 1976 · S/N 17702428 N679RMMattox Richard A · Friday Harbor, WABuilt 1977 · S/N 18052820 N679UPRegistration Pending · Maxwell, CARegistration pendingBuilt 1978 · S/N 18266598 N67ABScaglia Bennett P · Port Orange, FLBuilt 1975 · S/N A1500599 N67ADCjr Wings · Harrisburg, PABuilt 1976 · S/N 18265029 N67BJMccorkle Joseph Press II · Tyronza, ARBuilt 1961 · S/N 18050923 N67BL206 LLC · Keizer, ORBuilt 1967 · S/N P206-0397 N67BRDeep South Sky Llp · Wetumpka, ALBuilt 1973 · S/N 18261611 N67CHPrestige Aviation LLC · Lake Havasu City, AZBuilt 1981 · S/N 21064354 N67CNPrichard Brian E · Caledonia, MIBuilt 1968 · S/N 17257566 N67DGD&B Aircraft Leasing LLC · Anchorage, AKBuilt 1974 · S/N U20602375 N67DJSunrise Aero LLC · Nikiski, AKBuilt 1974 · S/N U20602326 N67DSHangar 39 LLC · Culpeper, VAS/N A185E1284 N67DVArizona Airplay LLC · Somerton, AZS/N 50359 N67EPViner Kevin Patrick · Encinitas, CAS/N P21000032 N67FPeterson Mark J · Flagstaff, AZBuilt 1953 · S/N 30343 N67GRQuinlan Sherman L · Georgetown, TXBuilt 1966 · S/N 15064854 N67JAJaars Inc · Waxhaw, NCBuilt 1980 · S/N U20605781 N67JKInternational Air Services Inc Trustee · Carson City, NVS/N P21000684 N67JMEck Gary A · Osceola, INBuilt 1973 · S/N 17701940 N67KEGran Tulley Corp · Arcadia, FLBuilt 1967 · S/N 18257834 N67MMSingh Ravinder · Happy Valley, ORBuilt 1975 · S/N 17702269 N67RAKirkwood Billie R · El Paso, TXS/N R172-0090 N67RVHopman Richard G · Oxford, MIBuilt 1966 · S/N 17255157 N67SSchultz Daniel A · Tipp City, OHBuilt 1974 · S/N P3370168 N67VMCreeque Alley Ventures LLC · Missoula, MTBuilt 1980 · S/N P21000568 N67WJBusiness As Usual LLC · Spartanburg, SCBuilt 1973 · S/N 15074915 N67WTHenderson Ronald W · Marietta, OHBuilt 1968 · S/N 18259488 N67WWFrontier Fence LLC · Fallon, NVBuilt 1966 · S/N 18051812 N67XLDavid E Morris Sr Enterprises LLC DBA · Mountainburg, ARBuilt 1983 · S/N P21000815 N6800APilots You Can Trust LLC · Fayetteville, NCBuilt 1956 · S/N 28900 N6800ENo Limits Aviation Inc · Hayden, IDFirst renewal noticeS/N 56300 N6800HBlack Industries LLC · Helena, MTS/N 17265587 N6800MTerhune Anthony L · Arlington, TNBuilt 1975 · S/N 18263844

Back to AD 87-20-03 R2