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.

N321PPMathews Aviation LLC · Marysville, CABuilt 1977 · S/N 18265834 N321RBMessmore Micheal Henry · Toledo, WABuilt 1976 · S/N 18052677 N321RZRieger Joseph M · Ashland, ORBuilt 1979 · S/N 18267199 N321TJCole Warren G · Watkinsville, GABuilt 1976 · S/N 17266807 N321TXMartin James K · Kingsville, TXBuilt 1967 · S/N 15067252 N321WFWings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17280987 N321WHBonanza Equipment Leasing LLC · Missoula, MTBuilt 1979 · S/N 18266927 N3220YTanner Fred E · Westville, FLS/N 18254327 N3221SPropwash LLC · Mesquite, NVBuilt 1964 · S/N 18255721 N3221VDevaney Aviation Inc · Palm City, FLBuilt 1974 · S/N 15076426 N3221YRegistration Pending · Brea, CARegistration pendingS/N 18254221 N3222DBeggs Patrick C · Salem, ORBuilt 1955 · S/N 32020 N3222LLanier James A · Phillipsburg, KSBuilt 1967 · S/N 17256122 N3222YCreighton Andrew M · Lebanon, TNBuilt 1962 · S/N 18254222 N3223DCliff Robinson Real Estate Corp · Madison, INBuilt 1955 · S/N 32021 N3223JPoulin Philip N · Washington, VTBuilt 1966 · S/N 15065923 N3223LBerube Leo Reginald · Easley, SCBuilt 1967 · S/N 17256123 N3223UPerry Joseph R · Portland, ORBuilt 1963 · S/N 18254623 N3224ARoy Timothy R · Cottrellville, MIBuilt 1953 · S/N 25868 N3224DE W Aircraft LLC · Manhattan, MTBuilt 1954 · S/N 32022 N3224SSkylane Trio Ltd · La Junta, COBuilt 1964 · S/N 18255724 N3224YCrouchet Jay · Kremlin, MTBuilt 1962 · S/N 18254224 N3225ASantacroce Anthony M · Cedar Rapids, IABuilt 1953 · S/N 25869 N3225LWing Nuts Inc · Maryville, MOBuilt 1967 · S/N 17256125 N3225UBlizzard Air LLC · Midland, TXBuilt 1963 · S/N 18254625 N3225YSamaritans Purse · Boone, NCS/N 18254225 N3226LStammen Dakota J · Stanley, NDBuilt 1967 · S/N 17256126 N3226SJones David A · Wasilla, AKBuilt 1964 · S/N 18255726 N3226YVaughn William Harrison · San Antonio, TXBuilt 1962 · S/N 18254226 N3227E3227e LLC · Jacksonville, FLBuilt 1978 · S/N 17271475 N3227JCanepa Joseph H · Baraboo, WIS/N 15065927 N3227LLown Robin F · Douglas, AKBuilt 1967 · S/N 17256127 N32282Watson Scott E · Wichita, KSS/N 18267033 N3228DNulsen Eric Randall · Greenbrier, ARBuilt 1955 · S/N 32026 N3228LWoodson Marcus L · Detroit, MIBuilt 1967 · S/N 17256128 N3228UTnt Rentals LLC · Wilmington, DEBuilt 1963 · S/N 18254628 N3228YFawley John M · Wisconsin Rapids, WIBuilt 1962 · S/N 18254228 N3229LTate Samuel Paul Baylon · Tacoma, WABuilt 1967 · S/N 17256129 N3229UEdwards Scott A · Lindsay, CABuilt 1963 · S/N 18254629 N322BFVann Russell B · Mangum, OKBuilt 1979 · S/N 17273231 N322CSGlembot Troy M Trustee · Winchester, VABuilt 2012 · S/N 18282341 N322EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12782 N322JWBravo Aircfraft LLC · Alpharetta, GABuilt 2026 · S/N 172S13521 N322KDI Fly High Flight Services LLC · Lovejoy, GABuilt 1973 · S/N 18262285 N322LKFindley Air LLC · Temecula, CABuilt 1974 · S/N 21060344 N322PHCafferty Associates Inc · Sarasota, FLBuilt 1972 · S/N 18261339 N322QBCaine Timothy · Bend, ORBuilt 1963 · S/N 18254620 N322TEEschmann Tim · Novinger, MOBuilt 2004 · S/N 18281372 N322TNExecutive Wings LLC · Bolivar, TNBuilt 1972 · S/N 15073812 N322WRBabineaux Kenneth W · Porter, TXBuilt 1977 · S/N 18266168

Back to AD 79-10-14 R1