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.

N730UOhio University · Albany, OHBuilt 2005 · S/N 2842224 N730XSbh Alliance LLC · Sauk Rapids, MNBuilt 2002 · S/N 2844066 N7310CC3 Aircraft LLC · Burnet, TXBuilt 1975 · S/N 28-7690066 N7311FRegistered aircraftBuilt 1968 · S/N 28-25225 N7311JBouley John T · Tolland, CTFirst renewal noticeBuilt 1968 · S/N 28-24658 N7314FAero Vantage Aviation Services LLC · Bayonne, NJBuilt 1968 · S/N 28-25272 N7314WWelch Tully D · Brackettville, TXBuilt 1963 · S/N 28-1177 N7315WPayne Victor · Brasstown, NCBuilt 1963 · S/N 28-1179 N7316WCallaboo LLC · Greenwood, SCBuilt 1963 · S/N 28-1180 N7317FMiller Steven G · Kent, WABuilt 1968 · S/N 28-25227 N7317JBengtson Timothy R · Boulder Creek, CABuilt 1968 · S/N 28-24666 N7318FTwo Weeks LLC · East Palo Alto, CABuilt 1968 · S/N 28-25228 N7318JHdr Aero LLC · Lewes, DEBuilt 1968 · S/N 28-24667 N7319FJdnichols LLC · Wichita, KSBuilt 1968 · S/N 28-25229 N7319JGross Randolph A · Round Rock, TXBuilt 1968 · S/N 28-24670 N7319WDavis Jeffrey M · Phoenix, AZBuilt 1963 · S/N 28-1184 N731ACAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881495 N731NDAir Shares LLC · Casper, WYBuilt 2016 · S/N 2843855 N731SMSkyline Flight Services LLC · Millen, GABuilt 1978 · S/N 32R7885116 N7320WSuchting Carl Joseph · Little Egg Harbor, NJBuilt 1963 · S/N 28-1186 N7321FWebster Joshua P · West Rutland, VTBuilt 1968 · S/N 28-25231 N7322FEdixon James Richard II · Cameron Park, CAS/N 28-25189 N7322WLocum Mike M · Sparta, TNBuilt 1963 · S/N 28-1190 N7323WHigh Desert Skys LLC · Blackfoot, IDS/N 28-1192 N7324WFerreira Barney Manuel · Truckee, CAS/N 28-1193 N7325JBasco Richard A · Charlotte, NCBuilt 1968 · S/N 28-24678 N7325WMitchell Lawrence Jr · Steubenville, OHFirst renewal noticeBuilt 1963 · S/N 28-1195 N7326FByrd Jonathan L · Rome, GAS/N 28-25235 N7326WHeinze William J · Ashley, MIBuilt 1963 · S/N 28-1196 N7327FAirconrad LLC · Duncansville, PAS/N 28-25236 N7327JWhite Benjamin M · Hallsville, TXBuilt 1968 · S/N 28-24681 N7327WCerto Russell · Grand Island, NYBuilt 1963 · S/N 28-1198 N7328JNightline Air LLC · Saratoga Springs, UTBuilt 1968 · S/N 28-24682 N7329FProflite Aero LLC · Easton, PABuilt 1968 · S/N 28-25237 N7329JWalser Air LLC · Warwick, RIBuilt 1968 · S/N 28-24683 N7329WHohl Warren G · Albany, GABuilt 1963 · S/N 28-1200 N732NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843856 N7330WAdventist World Aviation · Wilson, NCFirst renewal noticeBuilt 1963 · S/N 28-1201 N7331FGreenwood Stephen R · Salt Lake City, UTBuilt 1968 · S/N 28-25238 N7331JRitchey David C · Hilliard, OHBuilt 1968 · S/N 28-24685 N7331WBandit Aviation LLC · Batesville, MSBuilt 1963 · S/N 28-1091 N7332A4y Aviation LLC · Owasso, OKBuilt 1980 · S/N 32-8006049 N7332JRegistration Pending · Peculiar, MORegistration pendingBuilt 1968 · S/N 28-24686 N7335WWhitworth Kenneth W · Hanford, CARegistration expired, pending cancellationBuilt 1963 · S/N 28-1205 N7336JKey West Aviation LLC · Key West, FLBuilt 1968 · S/N 28-24691 N7336WDemers Matthew H · Plano, TXBuilt 1963 · S/N 28-1206 N7337WReynolds Jessica C · Maricopa, AZBuilt 1963 · S/N 28-1220 N7338WEvans Russell Slade · Austin, TXBuilt 1963 · S/N 28-1209 N7340WMillar Russell J · Saint Onge, SDS/N 28-1211 N7341JRicciardi John A · Norwalk, CTBuilt 1968 · S/N 28-24696

Back to AD 87-08-08 R3