Skip to content

Registered aircraft · 72,007

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N33641Sutton Aircraft Salvage LLC · Palmer, AKS/N 28-7505161 N33642Smith Gary E · Des Moines, IABuilt 1975 · S/N 28R-7535166 N33645Conner W Larry · Los Lunas, NMBuilt 1975 · S/N 32-7540108 N33648Sadiq Ahmed · Ontario, CABuilt 1975 · S/N 28-7525219 N3364THigh Mesa Aviation LLC · Naturita, COBuilt 1967 · S/N 17700664 N3364WOconnell Killian R · Amherst, MABuilt 1965 · S/N 32-210 N3364XDel Bene Dean A Trustee · Monee, ILBuilt 1966 · S/N 1085 N33655Gordon William S III · Aurora, COBuilt 1975 · S/N 28-7525220 N33659North Central Flight Center LLC · Warwick, RIBuilt 1975 · S/N 28-7515351 N3365BSmith James A · Lyle, WABuilt 1954 · S/N 22-2170 N3366Sutton Aircraft Salvage LLC · Palmer, AKS/N 23-1919 N33661Baker Justin Robert · Red Oak, TXBuilt 1975 · S/N 28-7505163 N33663Brown Tony Mac II · Bowling Green, KYBuilt 1975 · S/N 28R-7535171 N33666Hancock Carl M · Glendale, AZBuilt 1975 · S/N 28-7505165 N33667Aptum Aviation Inc · Hicksville, NYBuilt 1975 · S/N 28-7505166 N33668Northeast Cubs LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535172 N33669Ellsworth Donald · Beverly Hills, FLBuilt 1975 · S/N 32-7540110 N33672Nulton Enterprises LLC · Johnstown, PABuilt 1975 · S/N 28-7515298 N33673Borregard Robert Stephen · San Jose, CAS/N 28-7515306 N33674Beaulieu Marc R · Lewiston, MES/N 28-7525222 N33676Bous Harry John · Cayce, SCBuilt 1975 · S/N 28-7525224 N33679North Star Aviation Inc · Ulysses, KSFirst renewal noticeBuilt 1975 · S/N 28-7505167 N3367PJackson Lee Roy Jr · Needville, TXBuilt 1958 · S/N 23-1324 N33684Coletti John · Grant Park, ILBuilt 1975 · S/N 28R-7535174 N3368TTuley Richard L · Marietta, GARegistration revokedBuilt 1967 · S/N 17700668 N3368WRegistration Pending · Bulverde, TXRegistration pendingBuilt 1965 · S/N 32-214 N3368XI Have A Plane LLC · Lake Oswego, ORS/N 1087 N3368ZWatts Paul D · Weatherford, TXBuilt 1960 · S/N 22-7283 N33691Wide Open Aviation LLC · Kalispell, MTBuilt 1975 · S/N 28-7525227 N33692Horn Justin L · Hearne, TXBuilt 1975 · S/N 28-7505170 N33694Fly LLC · Natchez, MSBuilt 1975 · S/N 32-7500029 N33698Briggs Michael L · Howell, MIBuilt 1975 · S/N 28R-7535181 N33699Burris D Rob Trustee · Tucson, AZBuilt 1975 · S/N 32-7540116 N3369ERustmann Richard E · Willimantic, CTBuilt 1978 · S/N 17271520 N3369TBauer Charles · Graceville, MNS/N 17700669 N3369WBlue Sky Aviation LLC · Attleboro, MABuilt 1968 · S/N 32-1054 N3369XCollins Jerod William · Conifer, COBuilt 1966 · S/N 1088 N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404 N336BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881098 N336BWAllen Scott L · Ogallala, NEBuilt 2001 · S/N 4352 N336DBGustafson Gary E · Motley, MNBuilt 2005 · S/N 90805 N336FSRobinson Charles M Sr · Niceville, FLBuilt 2004 · S/N 14 N336JALundquist Eric John Jr · Houston, TXBuilt 2003 · S/N 81392 N336MAHot Wings Aviation LLC · Fishers, INBuilt 2024 · S/N 28020175 N336MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881087 N336NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2007 · S/N 120M N336PAWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 4496140 N336RABrown Donald B · Virginia Beach, VABuilt 1978 · S/N 3098 N336RVVose Kristin M · Bloomington, ILBuilt 2001 · S/N 60199 N336SBPieternelle J Coffy · Beaumont, TXBuilt 1973 · S/N 28-7305489

Back to AD 87-10-06 R1