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.

N4318UCragg Gordon · Georgetown, TXBuilt 1964 · S/N 15060318 N4319BClay Charles E · Alhambra, CABuilt 1955 · S/N 26663 N4319RWoodland William B · Anchorage, AKFirst renewal noticeBuilt 1976 · S/N 18502931 N431ARegistered aircraftBuilt 1976 · S/N 17265942 N431AFBuha Holdings LLC · Paris, TXBuilt 2003 · S/N 18281193 N431CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8693 N431CRAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11454 N431DKrause Derris O · Cumberland, MDS/N 15066583 N431FPSky West Aviation Inc Trustee · Albuquerque, NMS/N 172S9431 N431FRN3812q LLC · San Diego, CABuilt 1997 · S/N 17280301 N431MLFarr Francis A · Bozeman, MTBuilt 1975 · S/N 18263538 N4321QW H Flying Club Inc · Kingston, MIS/N 17260221 N4321UBurdett Michael R · Dawsonville, GABuilt 1964 · S/N 15060321 N4321XGrady Auctions & Realty Inc · Newport, ARBuilt 1965 · S/N 21058623 N4322LShastri Milind J · Seminole, FLBuilt 1966 · S/N 17254391 N4323LReed Darran K · Whitney, TXBuilt 1966 · S/N 17254392 N4323QWausau Flying Service Inc · Wausau, WIBuilt 1971 · S/N 17260223 N4323RMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263076 N4324LMesa Aviation LLC · Alpine, TXBuilt 1966 · S/N 17254393 N4324RShadle James A Jr · Gig Harbor, WABuilt 1974 · S/N 17263077 N4324UPerot Mark E · Homer, LABuilt 1964 · S/N 15060324 N4325BWattum Joel W · Wasilla, AKBuilt 1955 · S/N 26669 N4325LJ & F Aviation Adventure LLC · North Fort Myers, FLBuilt 1966 · S/N 17254394 N4325QBeier Mark E · Sylvania, GABuilt 1971 · S/N 17260225 N4325RGaruda Aviation Inc · Miami, FLBuilt 1974 · S/N 17263078 N4326BRopp Doug · Albany, ORS/N 26670 N4326QStar Fleet Aviation LLC · Bisbee, AZBuilt 1971 · S/N 17260226 N4326ULampley Timothy · Nolensville, TNS/N 15060326 N4327QFackler Aviation Services LLC · Clearwater, FLBuilt 1971 · S/N 17260227 N4327UHodges Caleb F · Omaha, TXBuilt 1964 · S/N 15060327 N4328QBetzner John C · Medway, MABuilt 1971 · S/N 17260228 N4329LHanson Randy J · North Branch, MNBuilt 1966 · S/N 17254398 N4329QElfers Brian K · Colfax, WAFirst renewal noticeBuilt 1971 · S/N 17260229 N4329UCarvalho Brandon A · Camarillo, CAS/N 15060329 N432AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2004 · S/N 172S9715 N432BAAnderson Jerry J · Vacaville, CABuilt 1956 · S/N 32279 N432CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13245 N432DTrollinger Lari D · Wanette, OKBuilt 1964 · S/N 15060762 N432DBDepcinski Travis A · Fairbanks, AKBuilt 1956 · S/N 32410 N432ELazy J Aeroplanes LLC · Beverly, WVBuilt 1969 · S/N 18259591 N432ERUnicorn Wings LLC · Cary, ILBuilt 1998 · S/N 17280652 N432MTFoundation Holdings LLC · Jonesboro, ARS/N 20608159 N432RRFirst Plane LLC · Erie, PAS/N 18267066 N432SUlman Morrison · San Carlos, CABuilt 1957 · S/N 32879 N432TSModern Air Solutions LLC · Panama City Beach, FLBuilt 1981 · S/N 18267862 N432ZADunbar Stephen E Trustee · Broken Arrow, OKS/N 15073805 N4330QSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 1971 · S/N 17260230 N4330UPalmer Dana G · Gatesville, TXS/N 15060330 N4331LOppegaard Craig E · Saint Louis Park, MNBuilt 1966 · S/N 17254400 N4331QLewis Brandon · Columbiaville, MIBuilt 1971 · S/N 17260231

Back to AD 79-10-14 R1