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.

N6690MWatson Joseph F · Colorado Springs, COBuilt 1975 · S/N 18263800 N6690SSeniram Air Inc · Wilmington, DEBuilt 1967 · S/N 15067490 N6690TAviation Connection LLC · Lake Worth, FLBuilt 1960 · S/N 15059090 N6690XWinston Marine LLC · Bellingham, WABuilt 1961 · S/N 21057690 N6692EMarshall Jerry J Sr · Parker, AZBuilt 1959 · S/N 56192 N6692GHopkins Marissa A · Cameron, MTBuilt 1970 · S/N 15072192 N6692MEagle Forestry Services Inc · Monticello, ARBuilt 1975 · S/N 18263802 N6692SNoltensmeyer Kurt Jon · Greenbank, WABuilt 1967 · S/N 15067492 N66931Laguna Verde Leasing Inc · Wilmington, DES/N 15281668 N6693HSwithenbank Leonard Co-Trustee · Fort Bragg, CABuilt 1975 · S/N 17265539 N66941Blue Mountain Airways LLC · Woodstock, GABuilt 1978 · S/N 15281676 N66946Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15281681 N66948Kuriger Michael R · Santa Clarita, CABuilt 1978 · S/N 15281683 N6694ADenslow Carl W · Barto, PABuilt 1956 · S/N 28794 N6694EThunderbird Aviation LLC · Littleton, COBuilt 1978 · S/N 17272050 N6694FWanagel Walter · Lisbon, CTBuilt 1966 · S/N 15063294 N6694GChatas John W · Ann Arbor, MIS/N 15072194 N6694NGear Down LLC · Dalhart, TXBuilt 1978 · S/N 21063150 N66954Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281689 N6695AStewart Guy C · Stevens Point, WIFirst renewal noticeBuilt 1956 · S/N 28795 N6695MRegistration Pending · Sheridan, WYRegistration pendingBuilt 1976 · S/N 17266695 N6695SOlsen Raymond E · Washington, UTBuilt 1967 · S/N 15067495 N6695TSischka Nicholas A · Haddon Heights, NJBuilt 1960 · S/N 15059095 N66964Tyler Daniel Jr · Durango, COS/N 17275994 N6696FYoung Deborah C · Lopez Island, WABuilt 1966 · S/N 15063296 N6696SJohnson Jay E · Murray, IABuilt 1967 · S/N 15067496 N6696XTesch Timm A · Spring, TXBuilt 1961 · S/N 21057696 N66970California Airways LLC · Hayward, CABuilt 1978 · S/N 15281696 N66971Meridian Airport Authority · Meridian, MSBuilt 1978 · S/N 15281697 N66977Unique Educational Experiences · Signal Hill, CABuilt 1978 · S/N 15281699 N66978Tupper Daniel A · Groveland, CABuilt 1983 · S/N 17275995 N6697AHart David L · Oxnard, CABuilt 1956 · S/N 28797 N6697EMartin Jonathan · Trumann, ARBuilt 1959 · S/N 56197 N6697FLogan Thomas H · Canfield, OHS/N 15063297 N6697GPaul William A · Windfall, INS/N 15072197 N66987De Brouwer Isabelle Mc · Alpine, TXS/N 56198 N6698TJeplawy Elizabeth A · Glenwood Springs, COBuilt 1960 · S/N 15059098 N6699AAdderley Allan M · Hernando, FLBuilt 1956 · S/N 28799 N6699EWheeldon Chancy R · Jackson Hole, WYBuilt 1959 · S/N 56199 N6699GBailey Matthew T · Cornelius, ORBuilt 1970 · S/N 15072199 N6699TFlory Michael Scott · Eldorado, TXBuilt 1960 · S/N 15059099 N669CBMckinney Eric · Hamersville, OHBuilt 1976 · S/N 18052725 N669EBBauman Ed · Casstown, OHBuilt 1975 · S/N 21061065 N669GAWilson Victor A · New Albany, OHS/N R172-0200 N669JKGeddes Michael · Seattle, WAS/N 15068277 N669NEAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 1981 · S/N 15285368 N669PGGood Pilot LLC · Dallas, TXBuilt 1975 · S/N 18263644 N669SRCabot Scott R · Cross Plains, WIBuilt 1970 · S/N 18260492 N66AALift Aviation LLC · Kingston, MABuilt 1977 · S/N 17270025 N66BDCampanella Stephen · Brunswick, OHBuilt 1960 · S/N 17248101

Back to AD 87-20-03 R2