Skip to content

Registered aircraft · 40,395

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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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.

N4129ZWild About Nature LLC · Fairbanks, AKBuilt 1965 · S/N 18-8199 N412BNBythrow Peter F · Columbia, MDBuilt 2003 · S/N 60400 N412DMMead Ronald C · Wichita, KSBuilt 1985 · S/N 412 N412FXCougar Aircraft Corp · Cheyenne, WYBuilt 1978 · S/N GA70035 N412HMCain Ryan C · Beaumont, CABuilt 1975 · S/N 20-1163 N412LClark Terry E · Dixon, MOBuilt 1954 · S/N 23-18 N412MRMundy Mark · Cape Coral, FLBuilt 1968 · S/N 680163 N412PCHelmen Harry W · Ruckersville, VABuilt 1956 · S/N 22-4311 N412SCMay Bob L · Wedowee, ALBuilt 1946 · S/N 12-868 N412WSArnold Jerry W · Lincoln, NEBuilt 1970 · S/N 17701475 N41306Bruns Darcy · Sandia, TXBuilt 1969 · S/N 17258310 N4130JOur Space Properties LLC · Camdenton, MOBuilt 1966 · S/N 28-22451 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 N4131UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843199 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 N4132YMartin Beaux R · Calhoun, LAS/N 234-76 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 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 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 N4135YMoore Steven J · West Ossipee, NHBuilt 1976 · S/N 953-76 N41361Excell Air Filters LLC · Ashland, OHS/N 28-7415186 N41369Ascent Aviation Inc · Van Nuys, CABuilt 1975 · S/N 28-7515370 N4136ENelson Gregory A · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 18-7809082 N4136PN4136p LLC · Titusville, FLS/N 23-1617 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 N4137ZAtg Enterprises Inc · Aztec, NMBuilt 1964 · S/N 18-8209 N41380Aristizabal Leonardo · Woodland Hills, CABuilt 1974 · S/N 28-7415194 N41383Lamontagne Bradley Theodore Jr · Pleasant View, TNBuilt 1974 · S/N 28-7425232 N41387Horizon Aviation LLC · Brooks, GABuilt 1972 · S/N 28-7225198 N41389Johnson David C · Chisago City, MNBuilt 1974 · S/N 28-7415197 N4138JRegistration Pending · Orlando, FLRegistration pendingBuilt 1966 · S/N 28-22461 N4138PFreyburger Gregory P · Strykersville, NYBuilt 1959 · S/N 23-1619 N4138XBroadwell Eric B · Woodstock, GABuilt 1968 · S/N 238 N4138ZZweifel Douglas L · Anchorage, AKS/N 18-8210

Back to AD 79-10-03 R2