Skip to content

Registered aircraft · 40,397

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.

N14WBeyer Mark E · Towanda, KSBuilt 1993 · S/N 11132 N14WFSamberg Scott S · Gillette, WYBuilt 1976 · S/N 233-76 N14WJSchifini Warren B · Dairy, ORS/N 2817 N14YBKate Air LLC · Southlake, TXBuilt 1979 · S/N 28-7990461 N14YLHarker James P · Blaine, MNBuilt 1945 · S/N 5-3005 N15000Central District Aviation LLC · Seattle, WABuilt 1969 · S/N 17258075 N15002Registered aircraftBuilt 1972 · S/N 28-7205315 N15003Flying Untethered LLC · Saranac Lake, NYBuilt 1972 · S/N 28-7225548 N15005Oliver Everett G · No Mankato, MNBuilt 1972 · S/N 28-7205316 N15010Van Buskirk James R · Tuttle, OKS/N 28-7225550 N1501XBowser William K · Ball Ground, GABuilt 1975 · S/N 28-7505235 N1502RSale Reported · San Diego, CASale reported, pending cancellationBuilt 1974 · S/N AA5B-0002 N15034Pathfinder Aviation Services LLC · St Johns, FLBuilt 1972 · S/N 28-7225557 N15037Ace Aircraft Leasing Inc · Nazareth, PABuilt 1972 · S/N 28-7225560 N1503RBeck Wally J · Davenport, IABuilt 1974 · S/N AA5B-0003 N1503XGasoline Valley LLC · Clyde, MIS/N 28-7525324 N1504AHise Kevin E · Rock Rapids, IABuilt 1951 · S/N 20-688 N1504JRuminski Pamela S · Salesville, OHBuilt 1967 · S/N 28-23897 N1504RFlying Tiger LLC · Broomfield, COBuilt 1974 · S/N AA5B-0004 N1504TChavez David L · Cedar Park, TXBuilt 1972 · S/N 28-7225500 N1504VCulman William A · Scotts Valley, CABuilt 1974 · S/N 17263633 N15050Houston William W · Baltimore, MDBuilt 1972 · S/N 28-7225569 N15057Bad Dog Aviation · Meridianville, ALBuilt 1972 · S/N 28-7225572 N15066Cherokee Aviation Group LLC · Alpharetta, GABuilt 1972 · S/N 28-7225577 N1506TWaldrep Zoey V · Tampa, FLS/N 28-7225538 N1506VDeshon Loren · Friday Harbor, WABuilt 1974 · S/N 17263634 N15079Rea Robert III · Bumpass, VABuilt 1972 · S/N 28-7225585 N1507EGonzalez Moya Camilo Rafael · Fort Worth, TXBuilt 1978 · S/N 17271028 N1507TAero Care Inc · Orange, MABuilt 1972 · S/N 28-7205310 N1508JLiwag Reynaldo T Jr · Niagara Falls, NYBuilt 1967 · S/N 28-23901 N1508RAmspoker David A · Kingman, AZBuilt 1975 · S/N AA5B-0030 N150AAReed Aviation Inc · Iota, LABuilt 1972 · S/N AA1A-0394 N150ABPurple Sage Aero LLC · Leonardtown, MDBuilt 1994 · S/N 04940068 N150AHRegistration Pending · Upland, CARegistration pendingBuilt 1993 · S/N 03930058 N150AKCamp Ted A · Williamson, GAS/N 04940071 N150ANBachman Aviation LLC · Independence, IABuilt 1995 · S/N 04940074 N150AQQualitair LLC Trustee · MichelstadtS/N 04940067 N150ATRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1994 · S/N 04940069 N150AYLegacy Aviation Foundation Inc · Staten Island, NYBuilt 1995 · S/N 04940073 N150BKTribec Inc · Medina, OHBuilt 1969 · S/N 15070857 N150CJMorrell John I · Seymour, TNBuilt 1994 · S/N 04940064 N150CWCleveland William L · Lander, WYS/N 18-4329 N150DHHollenbaugh Roger Dean · Jamestown, COBuilt 1987 · S/N 240 N150EPGedney William · Lake George, NYBuilt 1959 · S/N 18-7087 N150FSCustom Air International LLC · Homestead, FLBuilt 1975 · S/N 17265554 N150HCJones Luis · Las Vegas, NVS/N A1500725 N150HPGrimes Brian T · Kingman, AZS/N 001 N150KSSommers Stuart S · Newberg, ORBuilt 1951 · S/N 20-678 N150LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842193 N150MFRevolution Robotics Inc · Corvallis, ORBuilt 2001 · S/N 0015

Back to AD 79-10-03 R2