Skip to content

Registered aircraft · 81,733

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N4130NCentral Irrigation Supply Co · Watsonville, CABuilt 1998 · S/N 2843171 N4130PKoch William L · Barre, VTBuilt 1959 · S/N 23-1610 N41316Elliott Barry E · Lake Havasu City, AZBuilt 1974 · S/N 28-7415168 N41318Bailey Jeffrey R · Indianapolis, INBuilt 1974 · S/N 28-7415169 N4131JTomb Randall H Jr · Pittsburgh, PAFirst renewal noticeBuilt 1966 · S/N 28-22453 N4131MHarris Jaqai N · Juneau, AKBuilt 1947 · S/N 12-3031 N4131UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843199 N4131VBened Enterprises LLC · Jensen Beach, FLBuilt 1998 · S/N 3246120 N4131XElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1968 · S/N 230 N4131ZMacarthur Clinton W · Anchorage, AKBuilt 1965 · S/N 18-8201 N41320Dutchyshyn Harry V Jr · Pasadena, MDBuilt 1974 · S/N 28-7405092 N41327Sharp Penny E · Ocala, FLBuilt 1974 · S/N 28-7415171 N4132DDominguez Luis · Brownsville, TXBuilt 1999 · S/N 2843234 N4132JDubois Aviation Inc · Chino, CABuilt 2001 · S/N 28-22454 N4132YMartin Beaux R · Calhoun, LAS/N 234-76 N41331Heath Andrew · Lafayette, INBuilt 1974 · S/N 28R-7435169 N41338Andrews Limited LLC · Flint, MIBuilt 2008 · S/N 4356 N4133EHouse Larry A · Anchorage, AKBuilt 1978 · S/N 18-7809129 N4133PCoulson Michael D · Zanesville, OHBuilt 1959 · S/N 23-1613 N4133XAnfuso Keith · La Habra Heights, CAS/N 232 N41342Papoutsis Thomas J · Chambersburg, PAS/N 28-7405094 N41343Lkr Aviation LLC · Buckeystown, MDBuilt 1974 · S/N 28R-7435171 N41348Low George D · Newport, MIBuilt 1974 · S/N 28-7425227 N41349Minot Aero Center · Minot, NDBuilt 1974 · S/N 28-7415179 N4134JPriebe Aviation LLC · Waseca, MNBuilt 1966 · S/N 28-22456 N4134MHansen Kirk · Bayside, WIBuilt 1998 · S/N 3246124 N4134TDavis Stephen · Madera, CABuilt 1999 · S/N 2843206 N4134ZHuseby Terry L · Hulett, WYBuilt 1964 · S/N 18-8207 N41357Air Trek North LLC · South Saint Paul, MNBuilt 1974 · S/N 28-7425228 N41359Ayubi-Moak Jason S · Chandler, AZBuilt 1974 · S/N 28-7415184 N4135DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 2843219 N4135JValiair Limited Company Trustee · Casper, WYS/N 3246127 N4135MHardy Val D · Lewistown, MTBuilt 1947 · S/N 12-3034 N4135WTexins Flying Club · Mckinney, TXBuilt 1999 · S/N 2843244 N4135YMoore Steven J · West Ossipee, NHBuilt 1976 · S/N 953-76 N4136Johnston Joel D · Mead, WABuilt 1969 · S/N EA-1 N41360Cross Thomas Ad · Yacolt, WABuilt 1945 · S/N 5-1395 N41361Excell Air Filters LLC · Ashland, OHS/N 28-7415186 N41364Registered aircraftBuilt 1974 · S/N 28-7410057 N41369Ascent Aviation Inc · Van Nuys, CABuilt 1975 · S/N 28-7515370 N4136ENelson Gregory A · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 18-7809082 N4136MArmstrong Charles · Shelbyville, MIBuilt 1947 · S/N 12-3035 N4136PN4136p LLC · Titusville, FLS/N 23-1617 N4136ZBrazit LLC · Miami, FLBuilt 1999 · S/N 3246137 N41372Gorham Raymond A · Lock Haven, PABuilt 1974 · S/N 28-7415189 N41376Berkshire Aviation Enterprises LLC · Great Barrington, MABuilt 1974 · S/N 28-7415191 N41379Dzedzy Theodore Andrew Jr · Schwenksville, PABuilt 1974 · S/N 28-7415193 N4137LLuv 2 Fly Ada LLC · Ada, OKBuilt 1999 · S/N 2843249 N4137ZAtg Enterprises Inc · Aztec, NMBuilt 1964 · S/N 18-8209 N41380Aristizabal Leonardo · Woodland Hills, CABuilt 1974 · S/N 28-7415194

Back to AD 81-18-04 R2