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.

N29821Jks Enterprises Inc · Park Rapids, MNBuilt 1972 · S/N 18261233 N2982ASkywagon Pilots Inc · Santa Clara, CABuilt 1953 · S/N 30182 N2982JTijman Esteban M · Potomac, MDBuilt 1966 · S/N 15065782 N2982KHalcomb Billy J · Pond Creek, OKBuilt 1980 · S/N 18053146 N2982SHerzog Daniel L · Clinton, MIS/N 15066882 N2982XSale Reported · Lakeland, FLSale reported, canceledS/N 17700382 N2983DIngalsbe David L · Flowery Branch, GABuilt 1955 · S/N 26926 N2983FHalle Michael P · Livingston, TXBuilt 1966 · S/N 18257083 N2983XEagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17701365 N2984CRosser Brian K · Minden, NVBuilt 1954 · S/N 30884 N2984JBell Edward A · Richfield, OHBuilt 1966 · S/N 15065784 N2984UJuris Ronald D · Bickleton, WABuilt 1966 · S/N 17255040 N2984YRondeb Aircraft LLC · Wilmington, DEBuilt 1962 · S/N 18253984 N2985CBraham John P · Fairbanks, AKBuilt 1954 · S/N 30885 N2985JScott Jason Eton · Seattle, WABuilt 1966 · S/N 15065785 N2985UConnersville Flying Club Inc · Connersville, INBuilt 1963 · S/N 17250585 N2985XFrazier James R · Adamsville, TNBuilt 1967 · S/N 17700385 N2985YJones Aviation Inc · Biggs, CABuilt 1962 · S/N 18253985 N2986AMorris Blain E · Delta Junction, AKBuilt 1953 · S/N 30186 N2986EYbarguen Johnny C · Rosenberg, TXBuilt 1982 · S/N 18268225 N2986JWylam Thomas S · Ocala, FLBuilt 1966 · S/N 15065786 N2986KSmith John F III · Middletown, DEBuilt 1980 · S/N 18053149 N2986SHouglan Norman L · Shepherdsville, KYBuilt 1967 · S/N 15066886 N2986ULuebke Austin D · Corsica, SDS/N 17250586 N2987CYount Lawrence F · Shelton, WABuilt 1954 · S/N 30887 N2987DScheda Mark R · Brockport, NYBuilt 1955 · S/N 26930 N2987FRegistered aircraftBuilt 1966 · S/N 18257087 N2987KSpielvogel Heinz · Charlestown, RIBuilt 1980 · S/N 18053150 N2987UMott Charles A Jr · Chesapeake, VABuilt 1963 · S/N 17250587 N2988DBrown Hector M · Glenwood Springs, COBuilt 1955 · S/N 26931 N2988FTaf Aerial Services LLC · Beeville, TXBuilt 1966 · S/N 18257088 N2988JRegistration Pending · Asotin, WARegistration pendingBuilt 1966 · S/N 15065788 N2988KMelvin Perry D · Warner Robins, GABuilt 1980 · S/N 18053151 N2988UFrost Eddy L · Bishop, TXS/N 17250588 N2988XDoyle Thomas P · San Diego, CABuilt 1968 · S/N 17700388 N2989JWright Brandon C · Cave City, KYS/N 15065789 N2989UGodinez Mauricio U · San Diego, CABuilt 1963 · S/N 17250589 N2989XLabadie Enrique L · Tucson, AZBuilt 1967 · S/N 17700389 N298CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283020 N298DBButler John P · Hazelhurst, WIBuilt 2005 · S/N 18281595 N298GBSandhu Harpreet · Livermore, CABuilt 1977 · S/N 17268841 N298MCJ C B Aircraft Sales And Leasing · Princeton, NJBuilt 1997 · S/N 17280303 N298MEVermont Flight Academy Inc · South Burlington, VTBuilt 2000 · S/N 172S8557 N298PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10147 N298PLTextron Aviation Inc · Wichita, KSS/N 172S13653 N298SCCharlie Aviation LLC · Oregon City, ORBuilt 2024 · S/N 172S13241 N298SMSmb Flyer LLC · Queen Creek, AZBuilt 1973 · S/N 18262327 N298VBEdholm Joseph · Lino Lakes, MNBuilt 1959 · S/N 50364 N2990ATottle K M DBA · Limington, MEBuilt 1953 · S/N 30190 N2990CLyng Stephen G · Kenosha, WIBuilt 1954 · S/N 30890

Back to AD 79-10-14 R1