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.

N8395MJuliet Foxtrot Aviation LLC · Camden, SCBuilt 1969 · S/N A1500095 N8395QN8395q LLC · Ketchum, IDBuilt 1978 · S/N 18503680 N8395XAccurate Aviation LLC · Spring City, UTBuilt 1961 · S/N 172-48895 N8396GBarnes Greg B · Tunas, MOBuilt 1965 · S/N 15062496 N8396MManley Steven T · Dallas, TXBuilt 1969 · S/N A1500096 N8396SRegistration Pending · Livingston, MTRegistration pendingBuilt 1965 · S/N 18256496 N8396XKnierim Erik E · Puyallup, WABuilt 1961 · S/N 17248896 N8397BDiaz George D · Tucson, AZBuilt 1957 · S/N 36197 N8397JRegistered aircraftBuilt 1967 · S/N 15066297 N8397QSeattle Seaplanes LLC · Seattle, WABuilt 1976 · S/N U20603258 N8397TPennsylvania College Of Technology · Williamsport, PABuilt 1962 · S/N 17557097 N8397XGeist Jeffrey A · Avondale, PABuilt 1961 · S/N 17248897 N8397ZFlying H LLC · Lake Placid, FLBuilt 1963 · S/N 205-0397 N8398BThal James C · Fredericktown, MOBuilt 1957 · S/N 36198 N8398LWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 17256598 N8398MHale Richard W · Warminster, PABuilt 1969 · S/N A1500098 N8398SRoberts Rickey J · Kamiah, IDBuilt 1965 · S/N 18256498 N8398UAdrenaline Junkies LLC · Richfield, UTBuilt 1964 · S/N 17252298 N8398XCummings Thomas H · Lewistown, MTS/N 17248898 N8399BHumphrey William J · Whiteville, NCBuilt 1957 · S/N 36199 N8399LSanders George W Jr · Cloverdale, INBuilt 1968 · S/N 17256599 N8399SDenver Aviation Inc · Westminster, COS/N 18256499 N8399XWard Bruce · Fowlerville, MIBuilt 1961 · S/N 17248899 N839HFFour Boys Flying LLC · Kalispell, MTBuilt 1980 · S/N P21000633 N83BMShelton David B · Dallas, TXBuilt 1983 · S/N 21064799 N83CBDenton William P · Dallas, TXBuilt 1978 · S/N 18052992 N83CEElsner Kelly J · Menahga, MNBuilt 1980 · S/N P21000578 N83EWTremarco Philip J · Anchorage, AKS/N 17261231 N83FPPhillips Tom Scott · Beach City, TXBuilt 1978 · S/N 17271377 N83JLQualitair LLC Trustee · MichelstadtS/N F15001270 N83JVClark Jason · Gig Harbor, WABuilt 1983 · S/N 18268329 N83RBBerning Ron D · Lino Lakes, MNBuilt 1980 · S/N 18504069 N83SSSomd Seaplanes LLC · Lexington Park, MDBuilt 1973 · S/N 18502166 N83SWRogers Gary A · Novi, MIBuilt 1979 · S/N R18200625 N83TMCimino Joseph Michael · Decatur, ALBuilt 1977 · S/N A1520748 N84009Swenson Catherine A Trustee · Meadow Vista, CABuilt 1969 · S/N 17258299 N8400BEdwards R Deryl · Joplin, MOS/N 15062500 N8400JBlue Wings LLC · Brecksville, OHBuilt 1967 · S/N 15066300 N8400LInstant Print Signs & Designs LLC · Kalispell, MTBuilt 1968 · S/N 17256600 N8400QSpillman Aviation LLC · Colorado Springs, COS/N 18503682 N8400XBurlingame Craig D · Catlett, VABuilt 1961 · S/N 17248900 N84019Snodgrass William D · Moberly, MOFirst renewal noticeBuilt 1969 · S/N 17258303 N8401JKingdom Air Corps · Sutton, AKBuilt 1967 · S/N 15066301 N8401LBlack Baron Air LLC · Kalispell, MTS/N 17256601 N8401QJoseph Kenneth W DBA · Canton, OHBuilt 1978 · S/N 18503683 N8401UMorales Jerardo S · Belleville, ILBuilt 1964 · S/N 17252301 N8401XWilkinson Bert D · Sandpoint, IDBuilt 1961 · S/N 17248901 N84024Maurano Michael R · Long Island, VABuilt 1969 · S/N 17258304 N84026Smith William A Jr · Tulsa, OKBuilt 1969 · S/N 17258305 N8402LVan Bortel Inc · Victor, NYBuilt 1968 · S/N 17256602

Back to AD 87-20-03 R2