Skip to content

Registered aircraft · 22,416

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N787RSJjd Holdings LLC · Fort Madison, IABuilt 2005 · S/N 3232040 N787TFAir Fleet Holdings LLC · Missoula, MTBuilt 2022 · S/N 2881555 N787TKIal Corp · Lewes, DES/N 2881144 N7880WSefinas Avir LLC · Brooklyn, NYBuilt 1964 · S/N 28-1904 N7881WEast Crest Management LLC · Eastvale, CABuilt 1964 · S/N 28-1905 N7882CKeck Joseph S · Las Vegas, NVS/N 28-7625087 N7882WDickerson Gregory L · St Maries, IDS/N 28-1906 N7883WStack Brian James · Paso Robles, CABuilt 1964 · S/N 28-1907 N7885WCp Authority LLC · Poulsbo, WABuilt 1964 · S/N 28-1909 N7886WChelena Eric D · San Antonio, TXBuilt 1964 · S/N 28-1910 N7887WDepp Gregory B · Ft Worth, TXBuilt 1964 · S/N 28-1911 N7888WLashinski Michael J · Monument, COBuilt 1964 · S/N 28-1912 N7889WBetts Paula H · Valparaiso, INBuilt 1964 · S/N 28-1913 N788CADunekacke Joel F · Elk Creek, NEBuilt 1978 · S/N 32R-7887256 N788JAHot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020088 N788JGJg Aviation LLC · Westport, CTBuilt 2004 · S/N 3257369 N788RKSalomonsson Mats E · Hayward, CAS/N 28-24831 N788SStrauss Richard A · Palm City, FLBuilt 1981 · S/N 32R-8113097 N7891WN7891w LLC · North Las Vegas, NVBuilt 1964 · S/N 28-1916 N7892WRegistered aircraftBuilt 1964 · S/N 28-1917 N7894CAllen Rob · Lancaster, OHBuilt 1975 · S/N 28-7615066 N7894WWiley Thomas W · Anchorage, AKBuilt 1964 · S/N 28-1921 N7897WDimario Carmen · Wilmington, DEBuilt 1964 · S/N 28-1925 N7899WAmmon Sol · Papaaloa, HIS/N 28-1928 N789CMPierce Trey A · Tahlequah, OKBuilt 1968 · S/N 28-11165 N789DWFergus Falls Aviation LLC · Fergus Falls, MNBuilt 1973 · S/N 28-7325258 N789FBHot Wings Aviation LLC · Fishers, INBuilt 2025 · S/N 28020211 N789JAYale Companies LLC DBA Hot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020089 N789NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881307 N789PZarski Rebecca Cross · Sharon Springs, NYBuilt 1972 · S/N 28-7205303 N789PALong Jacob · Jupiter, FLBuilt 1975 · S/N 28-7525240 N789SVPaulukaitis Robert Adam · Hudson Oaks, TXBuilt 2023 · S/N 2881632 N78AARw Higginsllc · Armuchee, GABuilt 1977 · S/N 32R-7780239 N78BGKdrd Holdings LLC · Texas City, TXBuilt 1977 · S/N 28-7890100 N78DJKing David V · Mars, PABuilt 1978 · S/N 28R-7837171 N78EHN78eh Management LLC · Lewes, DEBuilt 1978 · S/N 32R-7887025 N78GBJones Richard · Cornville, AZBuilt 1978 · S/N 32R-7887282 N78JMDye William M · Atlanta, GABuilt 1976 · S/N 28-7690430 N78JSJet South LLC · Medford, NJBuilt 1978 · S/N 32R-7885152 N78LPStreamlineaero LLC · Omaha, NEBuilt 2007 · S/N 3257459 N78MJTalley Patricia · Asheboro, NCBuilt 1973 · S/N 28-7325319 N78MRShembekar Ajit R · Novi, MIS/N 32R-7987095 N78PLDunaway Dennis G Jr · Port Orange, FLBuilt 1978 · S/N 32R-7885040 N78QBPandion Aviation LLC · West Chester, PABuilt 1978 · S/N 28R-7837308 N78TACti Aircraft Leasing LLC · Memphis, TNBuilt 2020 · S/N 2881295 N78TMBowlin Ronald R · Camarillo, CABuilt 1977 · S/N 28-7890216 N78WARtd Aviation LLC · Hillsborough, NJBuilt 1977 · S/N 28R-7837077 N7900CSdd Aviation LLC · Thomasville, GABuilt 1975 · S/N 28-7690087 N7900WDiedrich Paul E · Fort Mill, SCBuilt 1964 · S/N 28-1929 N7901CFrost Aviation Alliance LLC · North Hollywood, CABuilt 1975 · S/N 28-7690088

Back to AD 87-08-08 R3