Skip to content

Registered aircraft · 896

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:99-15-04-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:99-15-04-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:99-15-04-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:99-15-04-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:99-15-04-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:99-15-04-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.

N9160ZBriggs Robert B · Germantown, TNBuilt 1989 · S/N 4622023 N9161KSkymook Aviation LLC · Beaver Falls, PABuilt 1989 · S/N 4622022 N9167MMalibu Rising LLC · Phoenix, AZBuilt 1986 · S/N 46-8608025 N916JAValiair Limited Co Trustee · Casper, WYBuilt 1993 · S/N 4622136 N9170XVb Inc · Show Low, AZBuilt 1989 · S/N 4622018 N9172VPowers Thomas · Pittsfield, VTS/N 4622038 N91734Lejeune Walter R III · Clarksville, TNS/N 4622040 N9174NPool Aaron · Houston, TXBuilt 1989 · S/N 4622054 N9176GQs Aviation LLC · Laredo, TXS/N 4622055 N917ATCk Auto Inc · Bismarck, NDBuilt 2009 · S/N 4636462 N9180XInternational Air Services Inc Trustee · Carson City, NVBuilt 1989 · S/N 4622075 N91902Ebe Aviation LLC · Urbandale, IABuilt 1990 · S/N 4622094 N9193RLos Compadres Ranch · Premont, TXBuilt 1990 · S/N 4622098 N9199POther Woman LLC · Gulf Shores, ALBuilt 1990 · S/N 4622107 N91MKMulaii LLC · Wilmington, DEBuilt 2014 · S/N 4636647 N91SDFlying High LLC · Plainfield, ILBuilt 1986 · S/N 4608035 N920CS R Plumbing LLC · Orlando, FLBuilt 2014 · S/N 4636638 N920DBColumbia Richard M · Pensacola, FLBuilt 2013 · S/N 4636608 N9214HJem Aviation Ltd · Wilmington, DEBuilt 1990 · S/N 4622114 N9219T19tango LLC · Newport Beach, CAS/N 46-8608015 N921KMLo Aircraft LLC · Key West, FLBuilt 2019 · S/N 4636741 N921RTAd Aviation LLC · Billings, MTBuilt 2018 · S/N 4636725 N9221MMiller Aviation Properties LLC · Abilene, KSBuilt 1985 · S/N 46-8608017 N92358Simmons Aviation Services LLC · Pawcatuck, CTBuilt 1993 · S/N 4622147 N9246MShenkirsch Consulting Inc · Mammoth Lakes, CABuilt 1993 · S/N 4622149 N924DCAirmann Leasing LLC · Mount Sterling, KYBuilt 1996 · S/N 4636057 N924TM & B Aviation LLC · Wake Forest, NCBuilt 2010 · S/N 4636466 N92521G&J Myles Aviation LLC · Owens Cross Roads, ALBuilt 1995 · S/N 4622191 N9253CJetstream LLC · River Forest, ILBuilt 1995 · S/N 4622183 N9255BAero Partners LLC · Sioux Falls, SDBuilt 1995 · S/N 4622197 N9257NJohn Bowman Inc · Fountain, COBuilt 1995 · S/N 4636006 N9260PRichter Scott J · Eden Prairie, MNBuilt 1996 · S/N 4636044 N9262GChampion Med LLC · Dover, DEBuilt 1995 · S/N 4636017 N9265RR2 Aviation LLC · Saint Matthews, SCBuilt 1996 · S/N 4636030 N9267QKandasamy David · Irvine, CABuilt 1996 · S/N 4636032 N926JDJosephs Howard I · Edgartown, MABuilt 2007 · S/N 4636422 N92714Registered aircraftBuilt 1996 · S/N 4636042 N92717Hold Fast Property LLC · Alto, NMBuilt 1996 · S/N 4636043 N92728Washington International Aviation LLC · Washington, DCBuilt 1996 · S/N 4636050 N9275YInternational Air Services Inc Trustee · Carson City, NVS/N 46-8608026 N92765N92765 Inc Trustee · Wilmington, DEBuilt 1996 · S/N 4636070 N927ROzinga Aviation Inc · Mokena, ILBuilt 2011 · S/N 4636509 N9280KN9280k LLC · Miami, FLBuilt 1997 · S/N 4636109 N92811Stephen Beazley Builders Inc · Evans, GABuilt 1996 · S/N 4636076 N9281BClear View Inc · Fort Smith, ARBuilt 1996 · S/N 4636074 N9281YSharp Darren J · Musselshell, MTBuilt 1986 · S/N 46-8608027 N92821Aerinova Inc · Mattoon, ILBuilt 1997 · S/N 4636081 N92835Ruff Aviation LLC · Asheville, NCBuilt 1997 · S/N 4636097 N9284X84x Leasing LLC · Idaho Falls, IDBuilt 1997 · S/N 4636087 N92884Bas Part Sales LLC · Greeley, COBuilt 1997 · S/N 4636107

Back to AD 99-15-04 R1