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.

N1797DBb Tacos And More Inc · Kalispell, MTBuilt 1951 · S/N 20239 N1797MCp & R Transport LLC · Grace, IDBuilt 1975 · S/N 18264450 N1797RNorthstar Holdings LLC · Anchorage, AKBuilt 1981 · S/N U20606331 N1797XN1797x Aero LLC · Gulf Breeze, FLBuilt 1975 · S/N 21060817 N1797ZReal Fly Air Service LLC · Jackson, WYBuilt 1963 · S/N 336-0097 N1798MWalker Steven C · Lake Havasu City, AZBuilt 1975 · S/N 18264451 N1798RSedwick Jack D III · Anchorage, AKBuilt 1974 · S/N 18502514 N1798XN1798x LLC · Etna Green, INBuilt 1975 · S/N 21060818 N1799RAir Support 1 Inc · Middletown, DEBuilt 1974 · S/N 18502515 N1799ZWanderlove Alaska LLC · Anchorage, AKBuilt 1963 · S/N 336-0099 N179CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282339 N179DBBrisco Daniel J · Fort Myers, FLS/N 15075498 N179JSMcdonald Timothy Steven · Slaton, TXBuilt 2004 · S/N 18281481 N179MMDe Schweinitz Christian R · Anchorage, AKS/N 19423 N179WSEbken Gary R · Loxahatchee, FLBuilt 1959 · S/N 51698 N179WZCatterton Jane S · Signal Mountain, TNBuilt 1981 · S/N 18268036 N179XPLadonne Frank · Fort Collins, COBuilt 1979 · S/N R1723155 N17ABBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 21057674 N17BHFoster Brian J · Mancelona, MIBuilt 1972 · S/N 18261384 N17BMNavigation Leasing LLC · Castle Rock, COBuilt 2023 · S/N 172S12978 N17BSSell William T · Orofino, IDBuilt 1965 · S/N 17252856 N17CJ16d Aviation LLC · Vashon, WABuilt 1968 · S/N U206-1199 N17DMLevin Jason Daniel · Aptos, CABuilt 1973 · S/N 177RG0420 N17FCUsda Forest Service Fepp · Columbia, SCBuilt 1970 · S/N 18260269 N17FGWard Bruce L · Key West, FLBuilt 1976 · S/N 15077906 N17GMNorthwestern Michigan College · Traverse City, MIBuilt 2021 · S/N 172S12769 N17GNGrant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 20700693 N17HPState Of Ohio Dept Of Public Safety · Columbus, OHBuilt 2004 · S/N 18281436 N17HSRed Oak Centurion LLC · Red Oak, IABuilt 1967 · S/N 21058844 N17HZLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 172-66345 N17JYYorkavitz James B · Valley City, OHBuilt 1969 · S/N 21059154 N17MMBekanich Jason · Camden, NCBuilt 1967 · S/N 18258323 N17MVNorthwestern Michigan College · Traverse City, MIBuilt 2020 · S/N 172S12598 N17NFBravo Hotel LLC · Lewes, DES/N P206-0369 N17NJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274527 N17SJAnson Air LLC · Sugar Land, TXBuilt 1999 · S/N 172S8344 N17SMN17sm LLC · Coral Springs, FLS/N 17272967 N17SRNcsb LLC · Anchorage, AKBuilt 1974 · S/N 18502424 N17TBarney Julius C · Lutz, FLBuilt 1968 · S/N 337-0990 N17TBOwen Bertha C · Port Saint Lucie, FLBuilt 1955 · S/N 27067 N17TCKenyon Walter C · Eureka Springs, ARBuilt 1964 · S/N 21058499 N17UPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1974 · S/N 17263440 N17YRNagle Jeffrey · Fremont, INS/N 18282456 N17ZSContinental Title Trust Co Trustee · Wichita, KSS/N 26632 N180Moore James M · Grass Valley, CABuilt 1978 · S/N 18052946 N18004Hause James H · Negley, OHBuilt 1972 · S/N 15073722 N18006Lockhart Curtis M · Bay Village, OHBuilt 1972 · S/N 15073724 N1800FReid Brian M · Boise, IDBuilt 1965 · S/N 21058700 N1800QNiswander Richard A · Upton, KYBuilt 1961 · S/N 18253196 N1800XValentine Edward Lawson · Dallas, TXFirst renewal noticeBuilt 1964 · S/N 18255900

Back to AD 79-10-14 R1