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.

N2793Y3y Leasing LLC · Englewood, COBuilt 1958 · S/N TD-166 N2795JEndeavour Flight Training Inc · Miami, FLBuilt 1979 · S/N 17273650 N2796WPennington Jeffrey B · Wrightwood, CABuilt 1966 · S/N 1072 N2797EPalm Beach Flyers LLC · Boca Raton, FLS/N 17271324 N2797WWebb John H Jr · Paulding, OHBuilt 1966 · S/N 1073 N27987Alaska Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N 31-7912054 N27989Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 31-7952077 N2798CStone Aviation LLC · Sacramento, CABuilt 1978 · S/N R18200228 N2798EPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N 17271325 N2798WSb Enterprise LLC · Marshall, TXBuilt 1966 · S/N 3367 N27990Aztec Worldwide Airlines Inc · Wilmington, DEBuilt 1979 · S/N 31-7952079 N279AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496507 N279CGDelaware State University · Dover, DEBuilt 2000 · S/N 2843399 N279JHBravo Zulu Aviators LLC · Midland, TXBuilt 1978 · S/N 32-7840138 N279KMarble Rick W · Hartford, IABuilt 2014 · S/N 90859 N279LGAltius Aviation LLC · Syracuse, NYBuilt 1986 · S/N 28-8611004 N279MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881020 N279NDSowela Technical Community College · Lake Charles, LABuilt 2000 · S/N 2844034 N279PWMauck Ryan S Trustee · Bend, ORBuilt 1985 · S/N 28-8590059 N279RARusso Robert Michael · Pipersville, PABuilt 2005 · S/N 1392-2005 N279RVStewart James L · Garden City, TXBuilt 2016 · S/N 90299 N279YRegistration Pending · Seneca, SCRegistration pendingBuilt 2008 · S/N 027 N27AHM W T Aviation LLC · Jamestown, NYBuilt 1975 · S/N 17265306 N27AMThom Jacob D · Wasilla, AKBuilt 1990 · S/N 001AM N27AUAndrews University · Berrien Springs, MIBuilt 2014 · S/N 2843768 N27AZGilbert John K · Austin, TXBuilt 2022 · S/N 1217 N27BEAir N Nautical LLC · Kalispell, MTBuilt 1998 · S/N 1418 N27BRLarson Allen L · Capron, ILBuilt 1969 · S/N 24-4909 N27CMM & J Enterprises · Union, SCBuilt 1979 · S/N 571 N27CYSale Reported · Hastings, FLSale reportedBuilt 1976 · S/N 27-7654118 N27DASiewruk Cameron M · Stuart, FLBuilt 1978 · S/N 32-7840084 N27DRN504fl LLC · Killeen, TXBuilt 2003 · S/N 24703 N27DVDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N T20608111 N27DWFritschle Derek R · Olney, ILBuilt 1975 · S/N 94 N27EGVetterman Larry D · Hot Springs, SDBuilt 2017 · S/N 062 N27FMGogoplex LLC · Wilmington, DEBuilt 1976 · S/N 27-7654087 N27GFAmerican Patrols Inc · Midland, TXBuilt 1981 · S/N 17274608 N27GSMazzola Michael · Baton Rouge, LABuilt 1977 · S/N 28R-7737160 N27GWWatson Gary R · Modesto, CABuilt 1982 · S/N 0002 N27GZKelly Kristofor · Belton, TXBuilt 2000 · S/N 01 N27HCCranston Courtland L · Santa Rosa, CAS/N 1 N27HPTrinair Aviation LLC · Hampshire, ILBuilt 1962 · S/N 27-2034 N27HRRemer Herbert I · Punta Gorda, FLBuilt 1999 · S/N 1444 N27HTTaylor Arthur W · Oswego, NYBuilt 2020 · S/N 20685 N27HUOlson Dorian J · Lake Park, MNBuilt 1997 · S/N 1359 N27HYMiand Inc · Laporte, INBuilt 1999 · S/N 1457 N27JOliver Paul D · Hedgesville, WVBuilt 1989 · S/N 1 N27JWGaither William W · Shallotte, NCS/N 17701148 N27KHume James W · Valley View, TXBuilt 1987 · S/N 1067A N27KKButler Robert Wynne Jr · Boyce, LABuilt 1962 · S/N 28-792

Back to AD 87-10-06 R1