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.

N2554CWard Wilbur B · Swannanoa, NCS/N 26198 N2554KBelleair Aviation LLC · Clearwater, FLS/N 18052985 N2554LAirheads Inc · Charles Town, WVBuilt 1967 · S/N 17255754 N2554RBartlett Richard H · Sussex, NJBuilt 1967 · S/N 18258254 N2554SHanan Roy T · Edgewater, FLS/N 337-0854 N2554UMustang Ops LLC · Orem, UTBuilt 1963 · S/N 17250154 N2554XWallin Justin · Henderson, NVBuilt 1964 · S/N P206-0054 N2554ZClement L Ross · Anchorage, AKBuilt 1963 · S/N 185-0554 N2555CLatham David C · Weld, MEBuilt 1954 · S/N 26199 N2555JRabenaldt Gilbert P · Telferner, TXRegistration revokedBuilt 1965 · S/N 15061055 N2555LGates Kimberly B · Kintnersville, PABuilt 1967 · S/N 17255755 N2555UBurull Donald E · Wichita, KSBuilt 1963 · S/N 17250155 N2556KCarlson Steven J · Fairbanks, AKS/N 18052986 N2556VLester Paul W · Hurricane, UTBuilt 1948 · S/N 18061 N2556XHusnik Brad M · Forest Lake, MNFirst renewal noticeBuilt 1964 · S/N P206-0056 N2556YZeafla Randall R · Elizabethtown, KYBuilt 1962 · S/N 17249856 N2557CJmte Aviation LLC · Appleton, WIBuilt 1954 · S/N 26201 N2557DFullerton John R · Fairbanks, AKFirst renewal noticeS/N 20709 N2557JSale Reported · Lake Havasu City, AZSale reported, canceledBuilt 1964 · S/N 15061057 N2557LSparks Ryan J · Peculiar, MOBuilt 1967 · S/N 17255757 N2557RWhite Willis W · Boise, IDBuilt 1967 · S/N 18258257 N2557UWings Of Hope · Chesterfield, MOBuilt 1963 · S/N 17250157 N2557XRegistration Pending · Troy, IDRegistration pendingBuilt 1964 · S/N P206-0057 N2557YSaddle Mountain LLC · Cave Creek, AZBuilt 1962 · S/N 17249857 N2558DClayton Alfred T Jr · Anchorage, AKBuilt 1952 · S/N 20710 N2558GScolari Shawn Fenton · Meeteetse, WYS/N 51858 N2558JHay Douglas E · Anza, CABuilt 1965 · S/N 15061058 N2558LHoecher Robert · Anchorage, AKS/N 17255758 N2558RKahn Steven P · Boise, IDBuilt 1967 · S/N 18258258 N2558UDelany Patrick J · Marion, TXBuilt 1963 · S/N 17250158 N2559LFlying Circus LLC · Bridgeport, WVBuilt 1967 · S/N 17255759 N2559QJordan Valley Aviation LLC · Jordan Valley, ORBuilt 1966 · S/N 18257759 N2559USnake River Flying Club LLC · Horseshoe Bend, IDBuilt 1963 · S/N 17250159 N2559XElement Building Solutions Inc · Murphys, CABuilt 1965 · S/N P2060059 N2559YA & D Precision Machining Inc · Fremont, CAS/N 17249859 N255ATThompson Aaron R · Louisville, KYS/N 18280060 N255CETextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2024 · S/N 18283255 N255EWollak John M · Mount Vernon, WABuilt 1976 · S/N 15078149 N255EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13316 N255FLCoutts Dylan A · Windsor, MEBuilt 1998 · S/N 18280241 N255KRAvra Valley Flyers LLC · Gilbert, AZS/N 172-69860 N255MEFalbo Michael Wayne · Sellersburg, INBuilt 2000 · S/N 18280765 N255PAAndresen Paul S · Chandler, AZBuilt 1955 · S/N 26735 N2560GJackson Air LLC · Temecula, CABuilt 1959 · S/N 51860 N2560JSmith Douglas J · Sidney, OHBuilt 1964 · S/N 15061060 N2560USpangenberg Daniel M · Greenville, MIBuilt 1963 · S/N 17250160 N2560VCrowley John Arthur · Visalia, CABuilt 1948 · S/N 18065 N2560XCd Hillcroft Aviation LLC · Superior, COBuilt 1965 · S/N P206-0060 N2561QMariposa Aviation Inc · East Wenatchee, WABuilt 1966 · S/N 18257761 N2561RHeber Valley Flying Club · Park City, UTBuilt 1967 · S/N 18258261

Back to AD 79-10-14 R1