Registered aircraft · 72,010

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.

N5839LHoyer Chase R · Jarrell, TXBuilt 1972 · S/N AA5-0039 N5839PSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-920 N5839QSnodgrass Michelle B · Sierra Vista, AZBuilt 1965 · S/N 785 N5839RGiraud Stephen · Box Elder, SDBuilt 1995 · S/N 20042C N583CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881132 N583FLSotomayor Edwin · Lacey, WABuilt 1971 · S/N 28-7125438 N583GWGentlemans Investments LLC · Camden, MEBuilt 1978 · S/N 14387 N583MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.399 N583NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496253 N583SVSouth County Aviation LLC · San Martin, CABuilt 2005 · S/N 372 N584Wyatt James · Conyers, GABuilt 1977 · S/N 0021 N5840UTall Timber Flying Service LLC · Kalispell, MTBuilt 1970 · S/N 28-26671 N5841DLeopold Gary L · Winterset, IABuilt 1956 · S/N 22-4520 N5841QGuziec Philip R · Riverwoods, ILS/N 786 N5841WDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2216 N5842LBerner Walter T III · Stamford, CTBuilt 1972 · S/N AA5-0042 N5842NAero Florida LLC · Geneva, FLBuilt 1978 · S/N 14390 N5842PFlyair Flight Academy LLC · Flint, TXBuilt 1959 · S/N 24-923 N5842QBradford Michael · San Jose, CABuilt 1965 · S/N 3130 N5842WFrakes Enterprises · Happy, TXBuilt 1965 · S/N 28-2221 N5843LMaschek Scott · Harker Heights, TXBuilt 1972 · S/N AA5-0043 N5843QKeane Christopher · Salem, NHBuilt 1965 · S/N 787 N5843UOnyx Aviation LLC · North Fort Myers, FLS/N 28-26674 N5843WSkyunityventures LLC · Richmond Hill, NYBuilt 1965 · S/N 28-2247 N5844LHennell Elizabeth · Orrville, OHBuilt 1972 · S/N AA5-0044 N5844WSmith William H · Weimar, TXBuilt 1965 · S/N 28-2237 N5845LKunkel Dennis J Co Trustee · Clearwater, MNBuilt 1972 · S/N AA5-0045 N5845PGriffel Brandon T · Frederick, MDBuilt 1959 · S/N 24-926 N5845ZGeldermann Bert E · Friday Harbor, WABuilt 1996 · S/N 230R N5846FDunning Steve L · Hopkinsville, KYBuilt 1976 · S/N 28-7790138 N5846QGardner Perry F · East Canaan, CTBuilt 1965 · S/N 3132 N5847PMyers Michael A · Indianapolis, INBuilt 1959 · S/N 24-928 N5847UFly Vermont LLC · Swanton, VTBuilt 1969 · S/N 28-26678 N5847WReed Charles W · Elizabeth City, NCBuilt 1965 · S/N 28-2286 N5847XFowler Leo W · Port Alsworth, AKBuilt 1941 · S/N 7896 N5847YC&C Aviation LLC · Amarillo, TXBuilt 1965 · S/N 27-2998 N5848AKnight Farms Inc · Pasco, WAS/N 001JRA N5848LN5848l LLC · San Francisco, CABuilt 1972 · S/N AA5-0248 N5848QValenti Edgar M · Gig Harbor, WABuilt 1965 · S/N 3133 N5848VSheffield David A · Silsbee, TXBuilt 1977 · S/N 32R-7780368 N5848WLedbetter Mark W · Garfield, ARBuilt 1965 · S/N 28-2292 N58490Kushner Herbert A · Bridgewater, NJBuilt 1997 · S/N 1094 N5849FGng LLC · Arlington, INBuilt 1976 · S/N 28-7790139 N5849PJinnis Flight Enterprises LLC · Montgomery, TXBuilt 1959 · S/N 24-930 N5849WHomic Michael J · Edmond, OKBuilt 1965 · S/N 28-2293 N584CALance Toland Ltd · Griffin, GABuilt 1993 · S/N 14584 N584CMBurns Timothy R · Eighty Four, PABuilt 1978 · S/N 24-0544 N584FBenesch Benjamin · Sparks, NVBuilt 2000 · S/N 5084 N584FLQuantum Aviation Services LLC · Lakewood Ranch, FLBuilt 1971 · S/N 28-7125439 N584JHSoaring Eagle Aviation LLC · Missoula, MTBuilt 2001 · S/N 84

Back to AD 87-10-06 R1