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.

N15343Bridger'S Hvac And Welding LLC · Milan, TNBuilt 1972 · S/N 28-7305061 N1534EStull Carl · Farmington, UTBuilt 1978 · S/N 17271038 N1534JChapman Melvin Newton II · Mishawaka, INBuilt 1967 · S/N 28-23934 N1535White Philip E · Hudson Oaks, TXBuilt 2010 · S/N 3335 N15354Stephen Swift · Justin, TXBuilt 1972 · S/N 28-7305062 N15355Brandvold Larry J · Fairfield, MTBuilt 1972 · S/N 28-7310037 N15358Daffer Jon T · Edgewood, NMBuilt 1972 · S/N 28-7310038 N15359Kobberdahl Matthew T · Maple Grove, MNBuilt 1972 · S/N 28-7325046 N1535XSmith James E · Wilson, NCBuilt 1975 · S/N 32-7540170 N15360Registered aircraftBuilt 1972 · S/N 28-7325047 N15361Williams Darren M · Carthage, ILBuilt 1972 · S/N 28-7305063 N15363Creativity Before Capital LLC · Tampa, FLBuilt 1972 · S/N 28-7310039 N15367Labrousse Ronald E · Tidewater, ORBuilt 1972 · S/N 28-7325048 N1536RCape Cod Aero Club LLC · Falmouth, MABuilt 1975 · S/N AA5B-0036 N15372Hollingshead Terry L · Flint, MIBuilt 1972 · S/N 28-7325050 N15373Johnson Brant T · Collinsville, OKS/N 28-7325051 N15374Smith William L · Supply, NCS/N 28-7325052 N15376Brown William D Jr · Mount Pleasant, TXBuilt 1972 · S/N 28-7305065 N15377Johnson Matthew · Biglerville, PABuilt 1972 · S/N 28-7305066 N15378Ketcham Jesse E · Aguanga, CABuilt 1973 · S/N 28-7305067 N15379Huyler John C · Shreveport, LABuilt 1972 · S/N 28R-7335053 N1537JYearta Philip T · Bono, ARS/N 28-23938 N1537XSale Reported · Milton, FLSale reportedBuilt 1975 · S/N 28-7515418 N15380Miller Aviation Group LLC · Coon Rapids, MNBuilt 1972 · S/N 28R-7335054 N15383Nevill Donald L · Clare, MIBuilt 1972 · S/N 32-7300006 N15388Smith John-Michael L · Austin, TXBuilt 1972 · S/N 28-7325054 N1538RAction Aerospace LLC · Bluffton, SCBuilt 1975 · S/N AA5B-0038 N1538VEvergreen Flying Club Inc · Medina, WABuilt 1974 · S/N 17263651 N1538XStaton Justin · Kemah, TXBuilt 1975 · S/N 28R-7535315 N15391Lyon Anthony R · Bethesda, MDBuilt 1972 · S/N 28-7305068 N15392Dgm Aviation LLC · Hurricane, WVBuilt 1972 · S/N 28-7305069 N15396Nomann Arnold H · Viroqua, WIBuilt 1972 · S/N 28-7310041 N15397Boisvert Thomas Michael · Sonoita, AZBuilt 1972 · S/N 28-7310042 N1539EMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17271040 N153ACN153ac LLC · Eldon, MOBuilt 1993 · S/N 702-93 N153AMMedford Daniel E · Lakeville, MNS/N 17702222 N153BAGeorge Tim D · Cleburne, TXBuilt 2010 · S/N 880211 N153BCMeierotto Jeff T · Two Rivers, AKBuilt 2011 · S/N BC-1 N153BDM & M Farms · Fowler, KSS/N 80939 N153CHarless Richard K · Battle Mountain, NVBuilt 1998 · S/N 1415 N153EJQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N 31P-8414011 N153GBBackovich George C · Pine Grove, CABuilt 2018 · S/N 1739 N153GHHealey David A · Hammondsport, NYBuilt 1966 · S/N 660602 N153GMFly High Aviation LLC · Melrose Park, ILBuilt 1992 · S/N 5266 N153JPPew John R · Casa Grande, AZBuilt 2007 · S/N 053 N153JRRs Helicopters Inc · Lake Wales, FLBuilt 1953 · S/N 3753 N153LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842196 N153LMSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7754019 N153MBaker Thomas J · Oxford, MDBuilt 2011 · S/N 82655 N153MCHollingshead Keith · Clarksboro, NJBuilt 2004 · S/N 60128

Back to AD 87-10-06 R1