Skip to content

Registered aircraft · 22,411

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.

N2111GScoggins Thomas H · Daytona Beach, FLBuilt 1979 · S/N 28-7990416 N2111MCarel Kenneth W · Corpus Christi, TXBuilt 1981 · S/N 32R-8113066 N2111SSchwab Jollina Michelle · Arlington, TXBuilt 1970 · S/N 28R-31048 N2111ZNunn Henry · Noble, OKBuilt 1973 · S/N 28-7305515 N21123Paris Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916027 N2112GA&J Aircraft Leasing Inc · Burlington, COBuilt 1978 · S/N 28-7816367 N2112KRocky Mountain Aircraft Services LLC · Broomfield, COBuilt 1978 · S/N 28-7990234 N2112NV & R Aviation LLC · Georgetown, TXBuilt 1979 · S/N 28-7990276 N2112TMarsh James M · Polkton, NCBuilt 1971 · S/N 28R-7130002 N2112ZWilson Mickey Ray · Skagway, AKBuilt 1979 · S/N 28-7990394 N21131Emge Douglas W · Albertville, ALBuilt 1978 · S/N 28-7990035 N2113GCarlson Lucas J · York, NEBuilt 1978 · S/N 28-7911071 N2113MEli Engineering & Manufacturing · Merrillville, INBuilt 1977 · S/N 28R-7803107 N2113T10 Mile Final 33 LLC · Charleston, SCBuilt 1971 · S/N 28R-7135058 N2114DDixie Sky Flight LLC · Deridder, LABuilt 1978 · S/N 28-7911033 N2114FChapel Hill Flying Club DBA · Sanford, NCBuilt 1978 · S/N 28-7916169 N2114JMonaco Joseph · Castleton, VTBuilt 1978 · S/N 28-7916224 N2114KRcs Services LLC · California, MDBuilt 1978 · S/N 28-7990235 N2114MKilo Delta Force LLC · Visalia, CABuilt 1977 · S/N 28R-7803108 N2114TPulka Michael R · Yardley, PABuilt 1971 · S/N 28R-7135060 N2114YMurphy Air Inc · Broadalbin, NYS/N 28-7921012 N2115BMisner Gear K · Phoenix, AZBuilt 1979 · S/N 32R-7987026 N2115JMartin Aviation LLC · Bargersville, INBuilt 1978 · S/N 28-7916196 N21167Tidewater Aviation LLC · Easton, MDBuilt 1978 · S/N 28-7916028 N2116FVarani Hugo Leonardo Cordova · Houston, TXBuilt 1978 · S/N 28-7916171 N2116JWard John C · Novato, CABuilt 1978 · S/N 28-7916197 N2116TBeshai Charles John · Huntington Beach, CABuilt 1971 · S/N 28R-7135061 N2116UBreaux Family Investments LLC · Alexander City, ALS/N 28-7990329 N2116ZBush Stanley D · Anthony, NMBuilt 1979 · S/N 28-7911150 N2117EWright Christopher Andrew · Lynn, MABuilt 1978 · S/N 28-7916163 N2117HEarl Nathan E · Noblesville, INBuilt 1978 · S/N 32R-7985045 N2117TCruce Aviation LLC · Marquette Heights, ILBuilt 1971 · S/N 28R-7135062 N2117USouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 28R-7918066 N21183Bkr LLC · Jacksonville, FLBuilt 1978 · S/N 32-7840184 N2118NBillberry Daniel · Chula Vista, CABuilt 1979 · S/N 28R-7918037 N2118TMein-Bar Inc · Pittsburgh, PABuilt 1979 · S/N 28R-7931083 N2119TTyler Kenneth A · Napa, CABuilt 1971 · S/N 28R-7135064 N211DCN211dc LLC · Los Angeles, CABuilt 1979 · S/N 28-7921037 N211NJCoco Aircraft Inc · Merritt Island, FLBuilt 1998 · S/N 2842043 N211VMGuardian Flight LLC · South Jordan, UTBuilt 1989 · S/N 2837030 N2120BAec Air LLC · Springfield, MOS/N 32R-7987027 N2121VOvcc Flyboys LLC · Tucson, AZBuilt 1979 · S/N 28-7921004 N2122GDavid Mieding Trustee · Reno, NVBuilt 1978 · S/N 32R-7985055 N2122JCharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 28-7916199 N2122LWare Pat · Farwell, TXFirst renewal noticeBuilt 1978 · S/N 28-7990257 N2122NOwen Jason Ryan · Fort Irwin, CABuilt 1979 · S/N 28R-7918039 N2122RAdventure North Flying Service LLC · Aitkin, MNS/N 28-5464 N2123AItechnology Design Inc · Gypsum, COBuilt 1978 · S/N 28-7990105 N2123JRegistered aircraftS/N 28-7990419 N2123KStone Kent H · Franklin, TNBuilt 1979 · S/N 28-7990238

Back to AD 87-08-08 R3