Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N5094RHigh View Air LLC · Driftwood, TXBuilt 1974 · S/N 17263332 N5095PGyrfalcon Air Holdings LLC · Boise, IDS/N 15284875 N5095RTraining Planes LLC · Tampa, FLBuilt 1974 · S/N 17263333 N50961Flight Skills LLC · Raleigh, NCBuilt 1977 · S/N 177RG1136 N50967Sellers Raymond L · Trussville, ALS/N 17264221 N50968Pacific Fleet Aviation LLC · Rochester, NYS/N 17274241 N5096GRiya Aviation LLC · Tracy, CABuilt 1979 · S/N 17273545 N5096HMyhre Norman G · Hixton, WIBuilt 1975 · S/N 17265339 N5096LPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284262 N5096XKanooth Michael L · Washougal, WABuilt 1969 · S/N 142 N50975N50975 LLC · Raleigh, NCBuilt 1980 · S/N 17274242 N50976Cape Aviation Services LLC · Hyannis, MAS/N 17274243 N5097EBenedikt Craig A · Clayton, GABuilt 1978 · S/N 17271710 N5097RPlymouth Flying Club Inc · Plymouth, NCBuilt 1979 · S/N 172RG0039 N5097VCamm Air · Spencer, IABuilt 1980 · S/N 172RG0447 N50988Propability One LLC · Daytona Beach, FLBuilt 1974 · S/N 17264223 N5098RWilliams Austin T · Sheridan, INBuilt 1974 · S/N 17263336 N5098VHarvestowne Aviation LLC · Saint Charles, MOBuilt 1980 · S/N 172RG0448 N5098XFontenot Reginald J · Church Point, LABuilt 1969 · S/N 162 N5099KSaari Michael · Sycamore, ILBuilt 1980 · S/N 17273969 N5099RFly High Aircraft Sales LLC · Ocilla, GABuilt 1974 · S/N 17263337 N5099VNew Horizon Aviation Inc · Warwick, RIBuilt 1980 · S/N 172RG0449 N5099XBailey Carlton D · Huntington, WVS/N 163 N509SMCompton Stephen · Kennewick, WABuilt 1974 · S/N 17263807 N50ACRegistered aircraftBuilt 1994 · S/N 1200-94 N50CAllred & Associates Inc · Skaneateles, NYBuilt 1965 · S/N 891 N50CLLopez Johnny · Henderson, NVBuilt 1976 · S/N 261-76 N50CPAtkins Daniel E · Marlette, MIBuilt 1978 · S/N R18200246 N50CXChristmas Candy · Angel Fire, NMBuilt 1979 · S/N R18201040 N50DDQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N P21000331 N50DTHarrell Ag Aviation LLC · Oak Grove, LABuilt 1975 · S/N 167-75 N50HLHerlth Clifford A · Cameron Park, CABuilt 1979 · S/N 24-0931 N50LRHester Truck Sales Inc · Bladenboro, NCBuilt 1995 · S/N 749-95 N50PGDrawe Richard · Progreso, TXBuilt 1994 · S/N 109575 N50PKGuinn Dennis R · Nevada, TXBuilt 1968 · S/N 17701311 N50RCBuric Ivan Nmn · Panama City, FLBuilt 1974 · S/N 177-02087 N50RHPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000738 N50RSStone Raymond J · Felton, DEBuilt 1977 · S/N 24-0177 N50SHVitatoe Industries Inc · Chillicothe, OHBuilt 1978 · S/N P21000178 N50THD&J Aviation LLC · Sandy, UTS/N 18267759 N50XDBest-Devereux Igor · Salt Lake City, UTBuilt 2015 · S/N 1161-2015 N50XTN50xt LLC · San Lorenzo, CABuilt 2014 · S/N 1150-2014 N50YYJambon Pierre · Port Orange, FLBuilt 2008 · S/N 1083-2009 N5100EWatson Lloyd Marshall · Sublette, KSBuilt 1978 · S/N 17271713 N5100GAero Leasing LLC · Snohomish, WABuilt 1979 · S/N 17273548 N5100QTulsa Technology Center School District 18 · Tulsa, OKBuilt 1981 · S/N 15285075 N5100VSmith Gordon J · Manhattan, KSBuilt 1980 · S/N 172RG0450 N5101HAberdeen Flying Service · Aberkeen, SDBuilt 1979 · S/N 15284061 N5101XWilliams Charles Edward · Scottsdale, AZBuilt 1969 · S/N 164 N5102DB & R Aircraft LLC · Wadsworth, OHBuilt 1979 · S/N 17272422

Back to AD 80-25-07 R1