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.

N35332Katchmar Michael L · Canon City, COBuilt 1968 · S/N 17256717 N35337Myer Martin John Trustee · Juneau, AKBuilt 1968 · S/N 17256718 N35339University Of Alaska Anchorage · Anchorage, AKS/N 172S8891 N3533CWestern North Carolina Air Museum · Hendersonville, NCBuilt 1954 · S/N 26576 N3533SDalton Joseph D · Circleville, UTS/N 17250733 N3533ULima 001 LLC · Muscatine, IAS/N 172S8890 N3533YFarley Sean D · Anchorage, AKBuilt 1962 · S/N 18254433 N35340Jones Donald E · Hollandale, MNBuilt 1968 · S/N 17256720 N35344Sawyer James E · Urbana, OHBuilt 1968 · S/N 17256721 N35345Flight One Holdings LLC · Devils Lake, NDBuilt 1968 · S/N 17256722 N35348Jet & Rotor Aviation LLC · Sacramento, CABuilt 1968 · S/N 17256724 N35349Stammich Thomas R · South Bend, INBuilt 1968 · S/N 17256725 N3534CHausback Brian Trustee · Sacramento, CABuilt 1955 · S/N 26577 N3534DWamsley Clayton O · Trimble, MOBuilt 1956 · S/N 27077 N3534FLackie Paul C · Melbourne, FLBuilt 1966 · S/N 18257534 N3534QLeatherneck Aviation LLC · Billings, MTBuilt 1969 · S/N 188-0484 N3534SInfinite Air Center LLC · Albany, ORS/N 17250734 N3534VJervis Joseph · Genoa, WVS/N 15076537 N35358N44344 LLC · Wasilla, AKBuilt 1968 · S/N 17256732 N3535JRegistered aircraftBuilt 1965 · S/N 15061235 N3535LToy Donald R · Homestead, IABuilt 1965 · S/N 15062335 N3535QBoulton Stephen A · Eugene, ORBuilt 1973 · S/N 17261666 N35362Hicks James P · Franklin, OHBuilt 1968 · S/N 17256734 N35367Hinds Community College · Bolton, MSS/N 17281068 N3536DRush Ray A · Palmer, AKS/N 27079 N3536GGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2001 · S/N 17281048 N3536LPnw Sky Trekking LLC · Colville, WABuilt 1965 · S/N 15062336 N35371Honrud Joseph C · Cal Nev Ari, NVS/N 17256738 N35373Registered aircraftBuilt 1976 · S/N 177RG1049 N35377Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1968 · S/N 17256740 N3537BDulles Aviation Inc · Bristow, VABuilt 2001 · S/N 172S8827 N3537DGross Thomas E · Mooresville, NCBuilt 1956 · S/N 27080 N3537FWatson James L · Burke, VABuilt 1966 · S/N 18257537 N3537JAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11614 N3537YCaton Robert M · Stafford, VABuilt 1963 · S/N 18254437 N35382Steele Aviation Inc · Walnut Cove, NCBuilt 1968 · S/N 17256742 N35383Scott Mark · North Andover, MABuilt 1968 · S/N 17256743 N35386Ehmann Stephen L · Holland, MIBuilt 1968 · S/N 17256745 N35387Southeastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281100 N35389Smith Martin P · Sedona, AZBuilt 2001 · S/N 172S8938 N3538DConrad Daniel Robert · Sweet Home, ORS/N 27081 N3538FGospel Ministries International Inc · Collegedale, TNBuilt 1966 · S/N 18257538 N3538JConnect With Aviation LLC · Everett, WABuilt 1965 · S/N 15061238 N3538LOne Seven Two Aviation Inc · Venice, FLBuilt 2001 · S/N 172S8953 N3538UVan Bilsen Aero LLC · Boise, IDBuilt 1963 · S/N 18254938 N35392Meinema Mathew · Fort Wayne, INS/N 17256747 N3539EGordon Robert A Jr · North Pole, AKBuilt 1958 · S/N 50398 N3539JSainer George F · Fort Worth, TXBuilt 1965 · S/N 15061239 N3539LCummings Kenneth · Camano Island, WABuilt 1965 · S/N 15062339 N353AWAirflow LLC · Missoula, MTBuilt 1998 · S/N 18280094

Back to AD 79-10-14 R1