Skip to content

Registered aircraft · 72,001

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N205ABAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1966 · S/N 211 N205APPappalardo Anthony · Vero Beach, FLBuilt 2000 · S/N 46-36250 N205CSFillwock Bryan T · Saint Joseph, MIBuilt 1977 · S/N 24-0223 N205DMSchmidt Myron Jake · Abingdon, MDBuilt 1999 · S/N 60205 N205DSUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 2002 · S/N 40.205 N205DTDeltgen James L · Janesville, WIBuilt 2005 · S/N 2014 N205FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020205 N205GTRegistration Pending · Chesnee, SCRegistration pendingBuilt 2002 · S/N 2054 N205HBMattes Michael Alan · Sherman Oaks, CABuilt 1977 · S/N 24-0288 N205HPBoyd Bill R · Kennett, MOBuilt 1973 · S/N M1696 N205JBSolsrud David A · Little Falls, MNFirst renewal noticeBuilt 1992 · S/N 713TD N205JHHarlan John M · Cedar Park, TXBuilt 1998 · S/N K055 N205KDBats Aero LLC · Missoula, MTBuilt 1986 · S/N 24-3017 N205MAWarbird Adventures Inc · Ocoee, FLBuilt 1979 · S/N 530-79 N205MXHlavnicka Thomas L · Big Sandy, MTBuilt 1999 · S/N 15006C N205PLQuinones Luis I · Gaithersburg, MDBuilt 1987 · S/N 24-3020 N205RGKeating Kevin C · Asheville, NCBuilt 1988 · S/N 243078 N205RLAlcott Thomas J · Jacksonville, ILBuilt 1987 · S/N 24-3022 N205SF242 Skies LLC · Troutman, NCBuilt 1977 · S/N 32R-7780311 N205SGWilliams Christopher · Wallingford, KYBuilt 2005 · S/N 3255041 N205SHBuzzard Aviation Inc · Freer, TXS/N 0773 N205TGLe Garrec Jean-Dominique M · Pittsburgh, PABuilt 1987 · S/N 24-3041 N205THAaces Flight Operations LLC · Ellisville, MOBuilt 1981 · S/N 28-8190282 N205WTHebron Jeffrey N · Trenton, SCBuilt 2019 · S/N 15-1534 N205ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881606 N20600Occupational Health Services · Green Bay, WIBuilt 1973 · S/N 17261432 N20601Gilfert James M · Sunbury, PABuilt 1973 · S/N 17261433 N20604Leffler Paul E · Churubusco, INBuilt 1973 · S/N 17261434 N20606Vander Roest Raymond · Scotts, MIBuilt 1973 · S/N 17261436 N2060EBlackstone Aircraft LLC · Hartselle, ALS/N 17271138 N20612Bentley Drive LLC · Anchorage, AKBuilt 1973 · S/N 17261440 N20613Taber Carl L · Trumansburg, NYBuilt 1973 · S/N 17261441 N20616Mcconnell Group LLC · Edwardsville, ILBuilt 1973 · S/N 17261442 N20617Mtnairpower LLC · Santa Barbara, CABuilt 2017 · S/N T20609522 N2061BM R O Drug Test Results LLC · Wintersville, OHBuilt 2003 · S/N 20608200 N2061ECak4 LLC · Uniontown, OHBuilt 1978 · S/N 17271139 N20621Bryant Jeffrey M · Pell City, ALBuilt 1973 · S/N 17261444 N20626Swingle Craig A · Hopewell, OHBuilt 1973 · S/N 17261447 N2062CBc Realty Group LLC · Lake Dallas, TXBuilt 1959 · S/N TD-262 N2062HRoonie Inc · Wilmington, DEBuilt 2002 · S/N 0133 N2062LJohnson Robert A · Crawfordville, FLBuilt 1976 · S/N M-1863 N2062MJadma LLC · Helena, MTBuilt 1977 · S/N 32R-7880051 N2062NRegistered aircraftBuilt 2002 · S/N S1830 N2062RMiller Mark T · Sugarcreek, OHBuilt 1969 · S/N 28-5447 N20634Jagoda William T Trustee · Rockfall, CTBuilt 1973 · S/N 17261449 N20636Spencer Ted B · Meridian, MSBuilt 1973 · S/N 17261451 N20637Dbj Aviation LLC · Venetia, PABuilt 1973 · S/N 17261452 N2063LPeterson Eric T · Port Townsend, WABuilt 1976 · S/N MB-809 N2063PRegistered aircraftBuilt 2005 · S/N 18281644 N20648Jones Farm Fresh LLC · Bartlett, TNBuilt 1973 · S/N 17261460

Back to AD 87-10-06 R1