Skip to content

Registered aircraft · 56,580

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

N3516DBickford Timothy · Limington, MES/N 27059 N3516FWhittock Tyson H · Anchorage, AKBuilt 1966 · S/N 18257516 N3516GHepler William J · Gratz, PABuilt 2001 · S/N 20608164 N3516JMitchell Clarence E · Las Cruces, NMBuilt 1965 · S/N 15061216 N3516SBenedict Greg · Mason City, IABuilt 1963 · S/N 17250716 N3516YMks Aviation LLC · Port Orchard, WABuilt 1962 · S/N 18254416 N3517CAnderson Robert A · Dove Creek, COBuilt 1954 · S/N 26560 N3517DStrange Willam H · Lewiston, IDBuilt 1955 · S/N 27060 N3517FCebelak William G · Kent City, MIBuilt 1973 · S/N A1500410 N3517SG & M Aircraft Inc · Wheat Ridge, COBuilt 2001 · S/N 17281083 N3517UAddison Robert M · Fort Sumner, NMBuilt 1963 · S/N 18254917 N3517VSt Cloud State University Aero Club Inc · Saint Cloud, MNBuilt 2001 · S/N 17281082 N3517YRobles Serafin M · Cynthiana, KYBuilt 1962 · S/N 18254417 N35182Beachy Michael H · Dundee, OHBuilt 1976 · S/N 177RG1045 N35183Stone Industrial Contractors Inc · Savannah, GABuilt 2001 · S/N 18281051 N35184Maliszewski William F · Independence, WIBuilt 2001 · S/N 18281002 N35185Stephens Brian A · Bruceville, INBuilt 1975 · S/N 17702252 N35186Mucci Eileen F · Wolcott, CTBuilt 1975 · S/N 17702253 N35188Landsearch LLC · Wilmington, NCS/N 18280999 N3518BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 20608163 N3518FPortmann James R · St Louis Park, MNBuilt 1966 · S/N 18257518 N3518SVarner Gregory A · Wasilla, AKBuilt 1963 · S/N 17250718 N3518YMcaninch Shawn R · Albia, IAFirst renewal noticeBuilt 1962 · S/N 18254418 N35191West Monte D · Coldspring, TXBuilt 1975 · S/N 17702255 N35192Huffman Robert V · Washington, DCBuilt 1975 · S/N 17702256 N35193Mccormack Duncan M · Sunfield, MIS/N 17702257 N35196Courtney Marshall Duchesne · Mission Hills, CABuilt 1975 · S/N 17702260 N35199Global Aerials Inc · Pembroke Pines, FLBuilt 1975 · S/N 17702261 N3519DLebold Mary Ann · Hubbard, ORBuilt 1955 · S/N 27062 N3519UG And D Aviation LLC · Sunfish Lake, MNS/N 172S8849 N3519VVanderpool Kenneth J · Portsmouth, NHBuilt 1974 · S/N 15076533 N3519YWeber Larry F · New Paltz, NYBuilt 1962 · S/N 18254419 N351BRRosenbaum Robert · Chilmark, MABuilt 1997 · S/N 18280045 N351CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283311 N351CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281386 N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918 N351JKeltz Bennie J · Hillsdale, INBuilt 1968 · S/N 188-0468 N351JSRainier Flight Service LLC · Renton, WABuilt 2025 · S/N 172S13355 N351MEPs N351me LLC · Green Bay, WIBuilt 2000 · S/N 172S8586 N35203Sky Views Aviation LLC · Red Lodge, MTBuilt 1975 · S/N 17702263 N35205Riley John Roland · Ouray, COBuilt 1976 · S/N 177RG1046 N3520CWallingford David P · Kenai, AKBuilt 1954 · S/N 26563 N3520FWood Forrest B · Cookson, OKBuilt 1966 · S/N 18257520 N3520JHart Robert J · Clarksville, MDBuilt 1965 · S/N 15061220 N3520LGregory Austin · Bothell, WABuilt 1965 · S/N 15062320 N3520SBrosnan James M · Staten Island, NYBuilt 1963 · S/N 17250720 N3520USchioppo Joseph · Boynton Beach, FLBuilt 1963 · S/N 18254920 N3520VHarrell Erick C · Sedona, AZBuilt 1977 · S/N R1722256 N35211Ballester Alexis R · Mayaguez, PRBuilt 1975 · S/N 17702267 N35213Aviation Adventure LLC · Munster, INBuilt 1975 · S/N 17702268

Back to AD 79-10-14 R1