Registered aircraft · 72,007

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.

N3398R3y3 Piper Group LLC · Saint Charles, IABuilt 1969 · S/N 28-5671 N3398XWinkers John W Jr · Woodstown, NJBuilt 1966 · S/N 1105 N3399ZAsquith-Heinz Quinn · Juneau, AKBuilt 1960 · S/N 18-7254 N339AMills Scott I · Littleton, COBuilt 2005 · S/N 90493 N339AGGirard Albert J · Portsmouth, RIBuilt 2017 · S/N 92001 N339ASMarkone Health LLC · Shelby, NCBuilt 2009 · S/N 60554 N339BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2022 · S/N 2881525 N339CSmith Cole · Parrish, FLBuilt 1999 · S/N 2044 N339CTPatel Niral G · Atlanta, GABuilt 1974 · S/N 27-7405350 N339DLFriedrich Robin K · Houston, TXS/N 90206 N339EEvans James W Jr · Wake, VABuilt 1985 · S/N 759 N339ECBlackmore Marc A · Hilltop Lakes, TXBuilt 1977 · S/N 20017 N339GOrsolits Robert M · Maitland, FLBuilt 2011 · S/N 361 N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119 N339MEShinkle Gordon · Gillette, WYBuilt 2000 · S/N 18280734 N339MKNorth Star Aviation · Mankato, MNBuilt 2019 · S/N 2881097 N339NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2006 · S/N 28010012 N339PJWallace James R · Aumsville, ORBuilt 2006 · S/N 90589 N339RVBillips Robert A · Bluefield, VABuilt 2016 · S/N 92170 N339SABig River Farms Inc · Natchez, MSBuilt 1999 · S/N 18280508 N339SCSea Seven LLC · Weatherford, TXBuilt 2014 · S/N SC007 N339TLeroux Todd C · Palmer, AKBuilt 1953 · S/N 18-2453 N339WLawson Richard Brandon · Ararat, NCBuilt 2000 · S/N 5657 N33AKMoses And Associates Inc · Gainesville, FLBuilt 1980 · S/N 61P08508163448 N33ANBarnes Gary Aaron · Huntsville, ALBuilt 1993 · S/N 625-320-0370FB N33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784 N33AVMaurer Sara Ann · Anchorage, AKBuilt 1996 · S/N 1332 N33AWWeigle Alan B · Seward, NEBuilt 2001 · S/N 489 N33BP33bp LLC · Sand Springs, OKBuilt 1992 · S/N 691-92 N33BYSellmeyer Flying Service · Knobel, ARBuilt 2005 · S/N 990-2005 N33CBShepperson Frank Lester · Midwest, WYBuilt 1958 · S/N 18-6682 N33CDElliott Kathy · South Thomaston, MEBuilt 1973 · S/N 17260989 N33CLBills Jacqueline Trustee · Willard, MOBuilt 1979 · S/N 28R-7918067 N33CMCharley Ernie · Gakona, AKBuilt 1976 · S/N 18-7609082 N33CRConstitutional Defense Arizona LLC · Scottsdale, AZBuilt 1977 · S/N 28-7725287 N33CTThree Wing Flight School LLC · Stratford, CTBuilt 1977 · S/N 28-7890136 N33CXK & S Irrigation Inc DBA · Higbee, MOS/N 10569 N33DBBowers Albert Joseph Jr · Aberdeen, MDBuilt 1970 · S/N 17701451 N33DHHarrington David · Lake Saint Louis, MOBuilt 1966 · S/N MB-4 N33DNRegistered aircraftBuilt 1969 · S/N 24-4896 N33DSAvion Ahoy LLC · Jacksonville, FLS/N 680176 N33DVKostreva Adam · Riverton, WYBuilt 1970 · S/N 234-70 N33ECMccammon Aviation LLC · Sullivan, INS/N 28-7225182 N33EFJarosak Theodore J Jr · Portage, INBuilt 1985 · S/N 1345 N33ELAdvancing Blade LLC · Glenwood, MNBuilt 1992 · S/N 20770 N33ERCrump Edward J · Boonton, NJBuilt 1978 · S/N AA5B0884 N33ESDuncan Ernest Michael · Dripping Springs, TXBuilt 1976 · S/N 28R-7635461 N33FKMotis Joseph D · Huntington Beach, CABuilt 1970 · S/N 28-5763 N33FUZeiset Karl D · Salmon, IDBuilt 1979 · S/N 241 N33GLJohnston Jeremy A · Cedar Springs, MIBuilt 1983 · S/N 532

Back to AD 87-10-06 R1