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.

N53772Quale Scott M · New Town, NDBuilt 1975 · S/N 542-75 N53773Brock Edwin G · Hawthorne, FLBuilt 1975 · S/N 1114-75 N53777Bernabucci Christian J · Mapleton, NDBuilt 1975 · S/N 877-75 N5377CAnderson Robert C · Zanesfield, OHBuilt 1977 · S/N 17702623 N5377DDesantis Anthony · Memphis, TNBuilt 1979 · S/N 17272552 N5377SHicks James S & Hicks Sally J Edgar Trustee · Oregon City, ORBuilt 1980 · S/N R18201560 N5377VShoemake Stephen Sidney · Pine Mountain, GABuilt 1980 · S/N 172RG0517 N53781Hayden Aviation LLC · Rhome, TXBuilt 1975 · S/N 1116-75 N53785Fox Business Advisors LLC · Mesa, AZBuilt 1975 · S/N 543-75 N53787Jones Carl L Jr · Edmond, OKBuilt 1975 · S/N 183-75 N5378BDraper Floyd L · El Paso, TXBuilt 1979 · S/N 15283855 N5378DMustang Sally Aviation LLC · Camden, SCBuilt 1979 · S/N 17272553 N5378ENuxoll Randy G · Eagle, IDBuilt 1978 · S/N 17271841 N5378KUnique Educational Experiences Inc · Signal Hill, CABuilt 1980 · S/N 17274087 N53791Maseman Paul A · Tucson, AZBuilt 1975 · S/N 887-76 N53794Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17274816 N53797Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274819 N5379ABrechtelsbauer Paul · Farmville, NCBuilt 1979 · S/N 21063403 N5379SStevens Michael J Trustee · Park City, UTBuilt 1980 · S/N R18201561 N537ACMacmillan John Jr · Chevy Chase, MDBuilt 2005 · S/N 999-2005 N537JHBuffington Matthew Hill · Highlands Ranch, COBuilt 1975 · S/N 533-75 N537NMasure Jason F · St Helena Is, SCBuilt 1979 · S/N 38-79A0428 N53800Blue Earth Flying Service LLC · Blue Earth, MNBuilt 1975 · S/N 321-75 N53801Stegman Edward L · Oceanside, CABuilt 1975 · S/N 1119-75 N53802Mcwhorter S Aaron · Whitesburg, GABuilt 1975 · S/N 880-75 N53804Bell Cody R · North Pole, AKBuilt 1975 · S/N 1120-75 N53806Quaal Christian M · Sundance, WYFirst renewal noticeBuilt 1975 · S/N 184-75 N53815Ag Solutions LLC · Garden City, KSS/N 546-75 N53817Rittberger Beef Inc · Hermosa, SDBuilt 1975 · S/N 882-75 N53818Prestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1975 · S/N 216-75 N53819Seekins Ralph DBA · Fairbanks, AKS/N 201-76 N53820Skylane Capital Group LLC · Seattle, WABuilt 1975 · S/N 547-75 N53822American Patrols Inc · Midland, TXBuilt 1981 · S/N 17274821 N53823Ferguson Carrie L · Palo Alto, CABuilt 1975 · S/N 1126-76 N53824Law C Scott · Oklahoma City, OKBuilt 1975 · S/N 884-75 N5382DEagles Flying Club · Saint Charles, MOBuilt 1979 · S/N 17272556 N53830Rives Taylor J · Buffalo, WYBuilt 1975 · S/N 548-75 N53832Kalis Dakota E · Blue Earth, MNBuilt 1975 · S/N 1127-76 N53834Morrison Dale C · Eloy, AZS/N 220-75 N53836Tailwheel Solutions LLC · Chagrin Falls, OHBuilt 1975 · S/N 1124-75 N53837Anderson Gene S · Whitewater, MTBuilt 1975 · S/N 886-75 N53838Euroaviation Inc Trustee · KematenBuilt 1975 · S/N 222-76 N5383ASummers Timothy P · Rincon, GABuilt 1979 · S/N 21063405 N5383DTong Sheng Aviation LLC · Irvine, CABuilt 1979 · S/N 17272557 N5383KAmerican Patrols Inc · Midland, TXBuilt 1980 · S/N 17274088 N5383MSunrise Aviation Inc · Ormond Beach, FLBuilt 1980 · S/N 15284572 N53840Lee Michael C · Concord, GABuilt 1975 · S/N 323-75 N53842Anderson Cody J · Orono, MES/N 1125-75 N53844Hughes Chandler · Sanger, CABuilt 1975 · S/N 551-76 N53845Sale Reported · Newfolden, MNSale reportedS/N 188-76

Back to AD 80-25-07 R1