Skip to content

Registered aircraft · 56,578

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.

N22830Delancey Eddie J · Elizabeth, WVBuilt 1968 · S/N 15068550 N22834Smith Earl K · Port Byron, NYBuilt 1968 · S/N 15068552 N22836Smith David R · Lebanon, TNBuilt 1968 · S/N 15068553 N22837Bielefeldt Brandon · Mondovi, WIBuilt 1968 · S/N 15068554 N22839Morris Bernard J · Davenport, FLBuilt 1968 · S/N 15068555 N2283JHill Douglas G · Winnebago, MNBuilt 1966 · S/N 15065483 N22846White Daniel M · Agua Dulce, CABuilt 1968 · S/N 15068559 N22847Blue Skies Aviation LLC · Alexandria, VAS/N 15068560 N2284CS L G Enterprises · Shelby Township, MIBuilt 1953 · S/N 30584 N2284EHarris Jeremy B · Sandy, ORBuilt 1948 · S/N 18389 N2284XWilson Gregory S · Cairo, MOBuilt 1965 · S/N 337-0184 N2284YBorn Daniel P · Lawrence, KSBuilt 1967 · S/N 17700084 N2285CIturriria John M · Kuna, IDBuilt 1953 · S/N 30585 N2285DJet Cane Corp · Roseville, CABuilt 1952 · S/N 20437 N2285GRensberger Scott C · Lake Jackson, TXBuilt 1958 · S/N 51585 N2285YKrid Cardinal LLC · Centerville, INBuilt 1967 · S/N 17700085 N22863Roberson Henry B · Chico, CABuilt 1968 · S/N 15068571 N22865Turner Tina L · Ford, WABuilt 1968 · S/N 15068573 N22867Jacobs Lydia A · North Pole, AKBuilt 1968 · S/N 15068575 N22876Rhoads Eric Scott · Costa Mesa, CABuilt 1968 · S/N 15068582 N22879Jones Dennis P · Nacogdoches, TXBuilt 1968 · S/N 15068584 N2287GLockwood William E · Carmel, NYS/N 51587 N2287RTail Winds To The Island Inc · Ashland, KYBuilt 1969 · S/N T210-0437 N22882Vasiliou Adamos C · Burtonsville, MDBuilt 1968 · S/N 15068586 N22886Sky High Adventures LLC · Wilmington, DEBuilt 1968 · S/N 15068589 N2288GSkydive Buckeye LLC · Buckeye, AZBuilt 1958 · S/N 51588 N22892Miller Frank L · Ninilchik, AKBuilt 1968 · S/N 15068593 N22893Hoffer Patrick N · Orr, MNBuilt 1968 · S/N 15068594 N22897Donn Rex · Washington, UTS/N 15068598 N228ANCalifornia In Nice Inc · San Jose, CABuilt 1981 · S/N 17274354 N228ARHurricane Creek Flying Club LLC · Walla Walla, WABuilt 1979 · S/N 17273580 N228CJSplashin LLC · White Lake, MIBuilt 1977 · S/N 17269610 N228CPColumbia Pacific Aviation Inc · Moses Lake, WABuilt 1978 · S/N 18266514 N228JASky Port Inc · Kalispell, MTBuilt 1976 · S/N 18265111 N228JPMazel Wings LLC · Camden, DEBuilt 2000 · S/N 18280711 N228KYPapalote Ranches LLC · Missoula, MTBuilt 1978 · S/N R1722883 N228NYFerguson Colt W · Wolf Point, MTBuilt 1959 · S/N 46482 N228TFTop Flight Aviation Inc · Corona, CABuilt 1979 · S/N 17273426 N228TMMacs Seaplane Service LLC · Milan, INS/N 17270902 N228TWNorth Delta Aviation LLC · Blytheville, ARBuilt 2002 · S/N 172S9228 N228WBSnell Jeffrey D · Inver Grove, MNBuilt 1974 · S/N 17263032 N228ZFFandrich Edward I · Payson, AZS/N 18502461 N22900Swanton Jed M · Shawnee, KSBuilt 1968 · S/N 15068601 N22902Easterling William R · Pikeville, NCBuilt 1968 · S/N 15068603 N22903Walther Newell A · Wasilla, AKBuilt 1968 · S/N 15068604 N22904Phoenix East Aviation LLC · Daytona Beach, FLS/N 172S9961 N22905Yokota Flight Training Center · Apo, APBuilt 1974 · S/N 17264078 N2290AOrtega Aviation Services LLC · Wichita, KSBuilt 2005 · S/N 172S9959 N2290DVan Roy Gary J · Seven Bays, WABuilt 1952 · S/N 20442 N2290GHooker John L · Iowa Park, TXBuilt 1958 · S/N 51590

Back to AD 79-10-14 R1