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.

N7674CFiyalko Wayne · Fort Myers, FLBuilt 1975 · S/N 28R-7635111 N7674FCarter Rhonda L · Columbiana, ALBuilt 1976 · S/N 28-7725101 N7674JAerofeather Aviation Inc · Suffolk, VABuilt 1968 · S/N 28R-31074 N7675JDimmlich Scot A · Conyers, GABuilt 1968 · S/N 28R-31075 N7675WAltitude Aircraft Leasing LLC · Burnet, TXBuilt 1964 · S/N 28-1642 N7676FNationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 28-7715234 N7676WEsparza Vincent A · Friona, TXS/N 28-1662 N7677FWestern Robert E · Stanley, NDS/N 28-7715235 N7677WNikolic Peter Jr · Momence, ILBuilt 1964 · S/N 28-1663 N7678WDsr-Cherokee 180 LLC · Dallas, TXBuilt 1964 · S/N 28-1665 N7679FScott Field Flying Club LLC · Elgin, IABuilt 1976 · S/N 28-7790215 N767CEReviere Russell E · Jackson, TNBuilt 1979 · S/N 28-8011047 N767CVNcv LLC · Jacksonville, FLBuilt 2001 · S/N 3257234 N767JGKd Aviation LLC · Warner Robins, GABuilt 1965 · S/N 32-52 N767LAN767la LLC · Philadelphia, PABuilt 2025 · S/N 28020219 N767NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881035 N7680FMag Avionics LLC · Woodlands, TXBuilt 1976 · S/N 28-7790217 N7680WMearbell Kevin J · Niagara Falls, NYBuilt 1964 · S/N 28-1667 N7682JAv Serv LLC · Dover, DEBuilt 1969 · S/N 28R-31083 N7682WMcintosh Doyle · North Ogden, UTBuilt 1964 · S/N 28-1670 N7683FFisch David S · Leland, NCBuilt 1976 · S/N 28-7725103 N7684FLettunich Mitchell C · Newcastle, CAS/N 28-7715238 N7686FBaremor Terry A · Brooklyn Park, MNBuilt 1976 · S/N 28-7715240 N7686JCovic Craig A · Cordova, TNBuilt 1969 · S/N 28R-31087 N7686WEcho Aviator LLC · Whitehouse, OHBuilt 1964 · S/N 28-1677 N7688CCable Bradley D · Indianapolis, INBuilt 1975 · S/N 28-7625080 N7688FLittle House In The Big Woods LLC · Nashville, INBuilt 1976 · S/N 28-7790219 N7688JClapp Rollyn D · Volga, SDBuilt 1969 · S/N 28R-31266 N7688WBurns Joyce A · Sparta, MOBuilt 1964 · S/N 28-1679 N7689FRed Arrow Aviation LLC · Santa Teresa, NMS/N 28-7790220 N768AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843793 N768CACollet Mark · Plymouth, MABuilt 1966 · S/N 32-594 N768NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843897 N7690FSparke Richard · Downers Grove, ILBuilt 1976 · S/N 32-7700007 N7690JFox Two LLC · Camino, CABuilt 1969 · S/N 28R-31071 N7690UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020278 N7690WEngelhuber Robert H · Beulah, MIFirst renewal noticeBuilt 1964 · S/N 28-1682 N7691WRoth Marshall Aviation LLC · Huntingdon, PABuilt 1964 · S/N 28-1683 N7692FCwh Properties LLC · Falls City, NES/N 32R-7780080 N7692JFlying Wings Of Louisiana · Denham Springs, LAS/N 28R-31092 N7693WRobinson Charles W III · Henderson, NCBuilt 1964 · S/N 28-1686 N7694FWolbert Dan S · Eagan, MNBuilt 1976 · S/N 28-7725104 N7694WBates Billy R · Summerville, SCBuilt 1964 · S/N 28-1687 N76957Airplane Flyers LLC · Nixa, MOBuilt 1975 · S/N 28-7690098 N7695WCircle 3k LLC · Nazareth, PAS/N 28-1618 N7696CHansmann Jacob W · Mahopac, NYBuilt 1975 · S/N 28-7610062 N7696FPompano Senior Squadron Flying Club Inc · Pompano Beach, FLBuilt 1976 · S/N 28-7715244 N7696WKohrell Jessica L · Cherry Valley, CABuilt 1964 · S/N 28-1696 N7697FTogether Again LLC · Charlotte, NCBuilt 1976 · S/N 28-7790222 N7697WBurmeister Robert A · Antelope, CABuilt 1964 · S/N 28-1698

Back to AD 87-08-08 R3