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.

N3499WAviator Solutions LLC · Oregonia, OHBuilt 1966 · S/N 32-379 N3499ZRedmond Perry · Fairfield, NDBuilt 1960 · S/N 18-7345 N349AMEdwards Jackie W · Mooresville, NCBuilt 2003 · S/N 2249 N349BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881690 N349CNaqua LLC · Commerce Township, MIBuilt 1999 · S/N 2043 N349CEBroussard Blake A · Youngsville, LABuilt 2009 · S/N 24481 N349CHAce Flight Center Inc · St Thomas, VIBuilt 1968 · S/N 27-3949 N349CWTyson Geoffrey · Vancouver, WABuilt 2002 · S/N 90102 N349DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843842 N349DMRitter John A · Yorktown, VABuilt 2010 · S/N 81556 N349EEConklin Ryan T · Camp Verde, AZBuilt 2006 · S/N 22905 N349ERWatkins Noble Marvin II · Port Saint Lucie, FLBuilt 1967 · S/N 28-3932 N349JMMortland Joseph A · Weymouth, MABuilt 1973 · S/N 17262619 N349JPCummings Danny L · Mcminnville, TNS/N 349 N349MNewhall Bud · Galt, CABuilt 1998 · S/N 10234 N349MAMa Sammy · S San Fran, CABuilt 2004 · S/N 3257349 N349MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881419 N349NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881902 N349RAPratt Stephen M · Waxhaw, NCBuilt 1978 · S/N 13178 N349RVJs Aircraft Group LLC · Lewes, DEBuilt 2020 · S/N 90015 N349SBSkyfusion II LLC · Atlanta, GABuilt 1977 · S/N 32R-7780480 N349SPWard Michael Allen · Quinlan, TXBuilt 1999 · S/N 172S8276 N349TWPilot Enterprises LLC · Norfolk, VABuilt 2006 · S/N S-0012 N34AJBiplane LLC · Bellingham, WABuilt 1973 · S/N 185 N34ARRobitaille Marc · East Bernard, TXBuilt 1990 · S/N 1209 N34CBCyrier John P · Lockhart, TXBuilt 1990 · S/N 2388 N34CZN34cz LLC · Port Saint Lucie, FLBuilt 1992 · S/N 2662 N34DAGlover William S · Mount Pleasant, TXBuilt 1958 · S/N 231469 N34DEStephens Justin R · Gatesville, TXBuilt 1988 · S/N DEG-1 N34DLAdlava LLC · Dover, OHBuilt 1966 · S/N 32-527 N34DNThomas Daniel Craig · Shady Shores, TXBuilt 2005 · S/N 498-2005 N34DVNelson Neil Wayne · Corvallis, ORBuilt 1988 · S/N 1619 N34DWDarvis Enterprises LLC · Addison, TXBuilt 1980 · S/N R18201522 N34EECodingflyboy LLC · Hayward, CABuilt 1966 · S/N 30-1138 N34ESTough Old Bird Aviation LLC · Beavercreek, OHBuilt 1973 · S/N 34-7450078 N34EXWilliams Dock G · Carmel Valley, CABuilt 2002 · S/N 165 N34FCN34fc LLC · Boise, IDBuilt 1985 · S/N 182-68-498 N34FGState Of Alaska · Fairbanks, AKBuilt 1978 · S/N 18-7809041 N34FMCordero Jose Robert · El Paso, TXFirst renewal noticeBuilt 1998 · S/N 27-0241 N34FXPietig Jacob T · Santa Cruz, CABuilt 1998 · S/N 1692 N34GHRoofing Guys LLC · Marion, ILS/N 10134 N34GRSeton Bruce B Jr · Port Townsend, WABuilt 2005 · S/N 55 N34HCSummit Concepts Inc · Wilmington, DES/N 293-320-55 N34HDWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1984 · S/N 17276259 N34HJGeissler Henry · Webster, MNBuilt 1999 · S/N 2317 N34HLDiller Calvin D · Hillsboro, ORBuilt 1995 · S/N 22126 N34JAN47me LLC · Tampa, FLBuilt 1979 · S/N 6005867961189 N34JCA2b Aviation LLC · Newark, OHBuilt 1978 · S/N 32-7840198 N34JTShowerman Mike T · Urbana, ILS/N 14JT N34KCCantrell Kenneth P · Lodi, CABuilt 2002 · S/N 60260

Back to AD 87-10-06 R1