Skip to content

Registered aircraft · 22,416

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.

N7501JSholl Douglas Alan Jr · Williams, AZBuilt 1968 · S/N 28R-30864 N7501WTide Pools LLC · Tucson, AZBuilt 1963 · S/N 28-1406 N75021Miller Mariemma L · Martinsburg, PABuilt 1976 · S/N 28-7625192 N7502JIrvin H Hugh · Salina, KSBuilt 1968 · S/N 28R-30866 N7502RStapleton James W Jr · Nebo, NCBuilt 1966 · S/N 28-22058 N75034Rpm Aviation LLC · Hillsborough, NCBuilt 1976 · S/N 32R-7680248 N75039Mulligan Peter · Richardson, TXS/N 28-7615237 N7503RQuinn George B · Ponce, PRBuilt 1966 · S/N 28-22059 N7503WAscend Aviation LLC · Bountiful, UTBuilt 1965 · S/N 28-2903 N75046Esson Michael · Durand, MIS/N 28R-7635261 N75047Dunlop Vance Trustee · Keizer, ORBuilt 1976 · S/N 28-7690285 N75048Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 28-7690286 N75049Christie Brian L · Irvine, CABuilt 1976 · S/N 28-7690287 N7504WThompson Reese F · Lake Stevens, WABuilt 1965 · S/N 28-2905 N75050Delaware State University · Dover, DEBuilt 1976 · S/N 28R-7635262 N75055Registered aircraftBuilt 1976 · S/N 28-7625196 N75056Warwick Kenneth Robert · Estill Springs, TNBuilt 1976 · S/N 28-7615242 N75057Gunter Jerry L Sr · Huntersville, NCBuilt 1976 · S/N 28-7615243 N75058Russell K C · Lindsay, CABuilt 1976 · S/N 28-7615244 N75059Markiewicz Mark J · Kokomo, INBuilt 1976 · S/N 28-7690289 N7505RMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 28-22061 N7506RGleason Joseph G · Gainesville, FLBuilt 1966 · S/N 28-22062 N75078Gibson Elizabeth Grace · Hamilton, NJBuilt 1976 · S/N 28-7615246 N7507RPanko Douglas A · Minooka, ILFirst renewal noticeBuilt 1966 · S/N 28-22063 N75080Dix Jeffrey G · Wausau, WIBuilt 1976 · S/N 28-7615247 N75082Up And Away Aviation LLC · Poughkeepsie, NYBuilt 1976 · S/N 28-7690290 N75084Wadas Burton J · Hudson, NHBuilt 1976 · S/N 28-7690292 N7508RTaylor Devan A · Overland Park, KSBuilt 1966 · S/N 28-22065 N75091Pettet David · Brook, INBuilt 1976 · S/N 32R-7680256 N75093Turner Barry D II · Mccook, NEBuilt 1976 · S/N 28-7625198 N75095Smith David Ross · Greensboro, NCBuilt 1976 · S/N 28-7615249 N750AWMagumbo Aviation LLC · Macomb, MIBuilt 1974 · S/N 32-7540018 N750GVTrak Inc · Gainesville, GABuilt 2000 · S/N 3257171 N750NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881030 N750UOhio University · Albany, OHBuilt 2005 · S/N 2842226 N75108Haga Christian K · Thousand Oaks, CABuilt 1976 · S/N 28-7625199 N75109Knox Warrior Corporation · Mount Vernon, OHBuilt 1976 · S/N 28-7615250 N7510JArmstrong Craig V · Casstown, OHBuilt 1968 · S/N 28R-30876 N7510RNewton Hayden R · Charleston, MSS/N 28-22067 N75110Triple R Aviation LLC · Cleburne, TXBuilt 1976 · S/N 28-7615251 N75114Henrichs Debra L · Galloway, OHBuilt 1976 · S/N 28-7690297 N75117Av8 LLC · Sandy, UTBuilt 1976 · S/N 28-7610109 N75124Scott David A · Alliance, OHBuilt 1976 · S/N 28-7615254 N75126Roth Darin · Max, NDBuilt 1976 · S/N 28-7690299 N75127Amob 2 LLC · Baton Rouge, LABuilt 1976 · S/N 28R-7635267 N7512JInfinity Aviation Group LLC · Nashua, NHS/N 28R-30879 N7512WNeblett Nathan · Fort Worth, TXBuilt 1965 · S/N 28-2908 N75130Tack Charles D · Apollo Beach, FLBuilt 1976 · S/N 32R-7680262 N75132Ferngulf Investments LLC · Loretto, MNBuilt 1976 · S/N 28-7625202 N75133Parmer Curtis S · Greensboro, NCBuilt 1976 · S/N 28-7615255

Back to AD 87-08-08 R3