Registered aircraft · 25,369

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.

N6596PAce Aircraft Leasing Inc · Nazareth, PABuilt 1981 · S/N 15285036 N6596ULipper Charles S Pers Rep · Stone Mountain, GAFirst renewal noticeBuilt 1962 · S/N 2378 N6597UAldo Leonardi · Woodland, CAS/N 2379 N6598UAdams Michael S · Huntsville, ALBuilt 1962 · S/N 2380 N6598WValiair Lc Trustee · Casper, WYS/N P21000802 N65994Christiansen Aviation LLC · Wilmington, DEBuilt 1983 · S/N 17275942 N6599DBlue Shield Aviation LLC · Saint Petersburg, FLBuilt 1979 · S/N 17272886 N659HCHowlett Corey · Wasilla, AKS/N 1140-79 N659MAStringham Charles A · Winnemucca, NVBuilt 2006 · S/N 1023-2006 N65AWSmith David W · Byhalia, MSBuilt 1965 · S/N 7ECA-241 N65DPPilawski Darren · Spring Hill, FLS/N 17257299 N65DZKing Dusty J · Little Elm, TXBuilt 1965 · S/N 2926 N65ECMartinez Fernando · Midland, TXS/N 791 N65EEEssler Kim L · Garrison, NDBuilt 1978 · S/N 24-0569 N65GLDavidson Amber M · Cocoa, FLBuilt 1964 · S/N 542 N65GVDemski Domenic Ross · Woodbridge, CAS/N 17271252 N65HTRoberts Bryan J · Norman, OKBuilt 1968 · S/N 680173 N65JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1977 · S/N 17268591 N65JXFlight World Inc · San Juan, PRBuilt 1980 · S/N 15284244 N65KDNorthwest Wings LLC · Hillsboro, ORBuilt 1974 · S/N 17264565 N65NURanard Douglas R · Dugger, INBuilt 1965 · S/N 773 N65PMKummer Mark · Hayden, IDBuilt 1982 · S/N 24-1312 N65PTBs Aviation LLC · Portland, ORBuilt 1976 · S/N 177RG1086 N65TXMitchell David Lamar · Ashdown, ARBuilt 1965 · S/N 2951 N65UFWright Stanley E · Houston, TXS/N 859-2000 N6600RDoyles Welding Lc · Phillipsburg, KSBuilt 1979 · S/N 172RG0206 N66015Rock Solid Aviation LLC · Lake Charles, LABuilt 1983 · S/N 17275948 N66018Executive Aviation LLC · Peoria, AZBuilt 1983 · S/N 17275949 N6601HCanby Pilots Club Inc · Canby, MNBuilt 1975 · S/N 17265503 N6601KAir Force Academy Aero Club · Usaf Academy, COBuilt 1980 · S/N 17274218 N6601RHolmes Donald R · Carlsbad, CABuilt 1979 · S/N 172RG0207 N6602CSnip Robert C · Telluride, COBuilt 1980 · S/N 21063926 N6602DLand Of Liberty LLC · Seminole, FLS/N 17272889 N6602HOver The Mountain Aviation LLC · Calera, ALBuilt 1975 · S/N 17265504 N66038Landrum Erik G · Austin, TXBuilt 1983 · S/N 17275953 N66049Aerosync LLC · Miami, FLBuilt 1983 · S/N 17275954 N6604EFlyn High Aviation LLC · Boynton Beach, FLBuilt 1978 · S/N 17272043 N6604UMr Dent Inc · Manheim, PABuilt 1963 · S/N 2391 N6605DAlameda Aero Club · Alameda, CABuilt 1979 · S/N 17272892 N6605PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 15285037 N6605UFoster Henry R · Saint George, SCBuilt 1963 · S/N 2392 N6606DRegistration Pending · Sturgeon Bay, WIRegistration pendingBuilt 1979 · S/N 17272893 N6606QAirtrust LLC - 1 - Series 1 Trustee · Sheridan, WYBuilt 1977 · S/N 18802951T N6606YBlackwell Benjamin D · Scottsdale, AZBuilt 1981 · S/N 21064457 N6607BWhalen Mark P · Millington, MDBuilt 1977 · S/N 18802984T N6607DVero Technical Support Inc · Pensacola, FLBuilt 1980 · S/N 17272894 N6607LGll Plane LLC · Ocala, FLBuilt 1980 · S/N 15284461 N6608BTucker William C · Phoenix, AZBuilt 1979 · S/N 15283959 N6608DAmericus Flying Club Inc · Americus, GABuilt 1979 · S/N 17272895 N6608RBogovich Robert E · Clifton, TXBuilt 1979 · S/N 172RG0210

Back to AD 80-25-07 R1