Skip to content

Registered aircraft · 40,394

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N7501WTide Pools LLC · Tucson, AZBuilt 1963 · S/N 28-1406 N75021Miller Mariemma L · Martinsburg, PABuilt 1976 · S/N 28-7625192 N7502DFlight Lead LLC · Casper, WYS/N 22-5229 N7502RStapleton James W Jr · Nebo, NCBuilt 1966 · S/N 28-22058 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 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 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 N7505DCronan Joseph M · Santa Maria, CABuilt 1957 · S/N 22-5232 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 N7507GEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 3240 N7507NKinzie Hon · Anchorage, AKBuilt 2002 · S/N 3321 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 N75093Turner Barry D II · Mccook, NEBuilt 1976 · S/N 28-7625198 N75095Smith David Ross · Greensboro, NCBuilt 1976 · S/N 28-7615249 N7509DPiggott Philip W · Peru, INBuilt 1957 · S/N 22-5236 N7509MFerry Douglas W · Santee, CABuilt 1959 · S/N 55809 N7509PSuperbird Aviation LLC · Atlantic, IABuilt 1961 · S/N 24-2710 N750KOgk Aviation LLC · Mandan, NDBuilt 1974 · S/N 18-7409134 N750TSN949md LLC · Blossom, TXBuilt 1996 · S/N 750-320-592FB N750UOhio University · Albany, OHBuilt 2005 · S/N 2842226 N750YTwo Bar Aviation Inc · Lincoln, NES/N 17263139 N751Pere Guy A · Cold Bay, AKBuilt 1978 · S/N 18-7909030 N75108Haga Christian K · Thousand Oaks, CABuilt 1976 · S/N 28-7625199 N75109Knox Warrior Corporation · Mount Vernon, OHBuilt 1976 · S/N 28-7615250 N7510EShier Aviation Corp DBA · San Diego, CABuilt 2002 · S/N 3380 N7510HVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1946 · S/N 12-371 N7510RNewton Hayden R · Charleston, MSS/N 28-22067 N7510UCrop Doctor Aviation Inc · Hill City, KSBuilt 2003 · S/N 3472 N75110Triple R Aviation LLC · Cleburne, TXBuilt 1976 · S/N 28-7615251 N75114Henrichs Debra L · Galloway, OHBuilt 1976 · S/N 28-7690297 N75124Scott David A · Alliance, OHBuilt 1976 · S/N 28-7615254 N75126Roth Darin · Max, NDBuilt 1976 · S/N 28-7690299 N7512CAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2003 · S/N 3484 N7512WNeblett Nathan · Fort Worth, TXBuilt 1965 · S/N 28-2908 N75132Ferngulf Investments LLC · Loretto, MNBuilt 1976 · S/N 28-7625202 N75133Parmer Curtis S · Greensboro, NCBuilt 1976 · S/N 28-7615255

Back to AD 79-10-03 R2