Skip to content

Registered aircraft · 54,015

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-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N7420GKellum Richard A · Seattle, WABuilt 1970 · S/N 17259120 N7420MRegistration Pending · Fort Recovery, OHRegistration pendingBuilt 1959 · S/N 55720 N7420XGreen Harold J · Spokane Valley, WAS/N 17247920 N7421AHarris David C · Ventura, CABuilt 1956 · S/N 29521 N7421GLibby Matthew P · Castle Hill, MEBuilt 1970 · S/N 17259121 N7421MMojzisik Allan W · Westerville, OHBuilt 1959 · S/N 55721 N7421TCostello Charles E · Greenfield, ILBuilt 1959 · S/N 47021 N7422ABeardsley Albert R · Byrdstown, TNBuilt 1957 · S/N 29522 N7422GLafayette Escadrille Flying Club · Rock Spring, GABuilt 1970 · S/N 17259122 N7422MFadling Daniel L · Port Orange, FLBuilt 1959 · S/N 55722 N7422QZimmer Steven F · Lacrosse, WABuilt 1972 · S/N 18261062 N7422XMacvey Troy R · Milan, INBuilt 1949 · S/N 7422 N7423NHolland Reggie K · Dillsboro, INBuilt 1974 · S/N 18263201 N7423XSierra Sky Aviation LLC · Kalispell, MTBuilt 1960 · S/N 17247923 N7424NBuck Carl W · Longmont, COBuilt 1981 · S/N 18504325 N7424THicks Kirby L · Dawson, GABuilt 1959 · S/N 47024 N7424XHigh Glide LLC · Tucson, AZBuilt 1960 · S/N 17247924 N7425EYoung James Steele · San Diego, CABuilt 1960 · S/N 57125 N7425GSmoke Eagles Inc · Downey, CABuilt 1970 · S/N 17259125 N7425NSteiner Stephen Trustee · Redding, CABuilt 1974 · S/N 18263203 N7425XLifer Craig · Hackettstown, NJBuilt 1960 · S/N 17247925 N7426AAdkins George E · Brooklyn, IABuilt 1956 · S/N 29526 N7426GProvoncha Tina · Oak Harbor, WABuilt 1970 · S/N 17259126 N7426MPhipps David B · Scottsdale, AZBuilt 1959 · S/N 55726 N7426SDanick Mechanical Inc · Nicolaus, CABuilt 1981 · S/N R18201711 N7426XTraverse Air Inc · Traverse City, MIBuilt 1960 · S/N 17247926 N7427AFlaps Forty LLC · East Wenatchee, WABuilt 1956 · S/N 29527 N7427GWilliams Jason R · Cordova, TNBuilt 1970 · S/N 17259127 N7427QDavidson William F · Port Orange, FLBuilt 1972 · S/N 18261067 N7428NHawthorn Transportation LLC · North Sioux City, SDBuilt 1974 · S/N 18263206 N7428THallstrom Steven D · Pasco, WABuilt 1959 · S/N 47028 N7429GDiditair Inc · Knoxville, TNBuilt 1970 · S/N 17259129 N7429NWholly Guacamole LLC · Steamboat Springs, COBuilt 1974 · S/N 18263207 N7429TDasilva David S · Catasauqua, PABuilt 1959 · S/N 47029 N7429XDolezal Thomas J · Mineral, VABuilt 1960 · S/N 17247929 N742ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701646 N742DC5c Aviation Inc · Boise City, OKBuilt 1974 · S/N 18262821 N7430ANeilsen Lorenzo I · Wilmington, NCBuilt 1956 · S/N 29530 N7430EBallesteros Irlena · Glendale, CAS/N 57130 N7430QFlying Paws Aviation LLC · Louisville, COBuilt 1972 · S/N 18261070 N7431AAero Care Inc · Orange, MAS/N 29531 N7431EGeyer Austin D · Minot, NDS/N 57131 N7431MWestern Pacific Systems Inc · Anchorage, AKS/N 55731 N7431NWe Fly LLC · Fort Payne, ALBuilt 1974 · S/N 18263209 N7431TKorinko Seana L · Rostraver Township, PABuilt 1959 · S/N 47031 N7431XVannier Aviation LLC · Sheridan, ORBuilt 1960 · S/N 17247931 N7432GNichols Roy D · Cadillac, MIBuilt 1970 · S/N 17259132 N7432NJensen David F · Clarks Grove, MNBuilt 1974 · S/N 18263210 N7432QWatkins Daniel L · Fuquay Varina, NCBuilt 1972 · S/N 18261072 N7432SAnderson Jeffery G · Calhoun, LABuilt 1976 · S/N 18265194

Back to AD 87-20-03 R2