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.

N22YPEmb500 Inc · Saint Petersburg, FLBuilt 2013 · S/N 1125-2013 N2305YOtt Nicholas D · Mobile, ALBuilt 1967 · S/N 17700105 N2306DUS Navy - Owner · Jacksonville, FLBuilt 1979 · S/N 21063828 N2306YEagle Sky Patrol Inc · Deadwood, SDS/N 17700106 N2307General Aviation Support Corp · Rosamond, CAS/N 17274920 N23078Pureflight Aviation Training LLC · Newberg, ORBuilt 1974 · S/N 17264080 N2308EPavco Inc · Gig Harbor, WABuilt 1978 · S/N 17271228 N2308YAltman Richard A · Albuquerque, NMBuilt 1967 · S/N 17700108 N230MAParker-Omalley Corp · Chatham, NYBuilt 2004 · S/N 953-2004 N230MMLackey Matthew Allen · Peachtree City, GABuilt 1980 · S/N R18201529 N230RVEast Tennessee Aviation LLC · Mountain City, TNBuilt 1973 · S/N 17261598 N230SVSwailes Craig · Taylor, MIBuilt 1979 · S/N 152-83257 N2313NClark Randy L · Burlington, COBuilt 1979 · S/N 38-79A0781 N23140Flora James L · Mitchell, INBuilt 1981 · S/N 38-81A0119 N2314EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271230 N2314KWebb Bennie K · Fitzgerald, GAS/N 38-79A0571 N2315VAnywhere Atp LLC · Mount Juliet, TNS/N 38-82A0085 N2316YWhitacre James P · Martinsburg, WVBuilt 1967 · S/N 17700116 N23173Garza David J · Mcallen, TXBuilt 1981 · S/N 38-81A0123 N2317BCylinder Optics Inc · Garden City, MOS/N 38-79A0007 N2317DClint Edward K · Littleton, COS/N 38-79A0269 N231PMBernard Raymond C · Melba, IDS/N 541-2011 N231PTLobbytools Aviation LLC · Friday Harbor, WABuilt 1980 · S/N P21000551 N231SCBice Crystal Harmon · Temple, GABuilt 1974 · S/N 17264523 N2320ESky Farmer LLC · Culleoka, TNS/N 17271232 N2320VAlpha Aviation Holdings Group LLC · Raleigh, NCS/N 38-82A0040 N2321GMakara Stanley J · Islesboro, MES/N 38-79A0496 N2324DGrove Thomas T · Midlothian, TXBuilt 1978 · S/N 38-79A0274 N2324GHadley Everett F · Dayville, CTBuilt 1979 · S/N 38-79A0497 N2326EKirk Jeff R · Colorado Springs, COBuilt 1978 · S/N 38-78A0443 N2326NDilts Airplane Leasing LLC · Wichita Falls, TXBuilt 1979 · S/N 38-79A0790 N2327KForrest John L · Weatherford, TXS/N 38-79A0576 N23281Sosa Jonathan · Orlando, FLBuilt 1974 · S/N 17264082 N2328CZimmerman Jeremy Jerard · Riverside, CAS/N 38-79A0154 N2328KWilliams Robert W · Lees Summit, MOS/N 38-79A0577 N2328YRogue Air LLC · Miller, SDBuilt 1967 · S/N 17700128 N23291Oracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264083 N2329EMeshoppen Air LLC · Meshoppen, PABuilt 1978 · S/N 17271235 N232CBLight Air Development LLC · Helena, MTBuilt 1976 · S/N 177RG0998 N232JTBlezek Kent D · Tustin, CABuilt 1978 · S/N 24-0727 N232LSElliott Arthur M · Portland, TXBuilt 1971 · S/N 17260131 N232WMFilkins Barbara · Fillmore, CABuilt 1999 · S/N 830-99 N2330DDemeyer Garrett J · Fort Walton Beach, FLBuilt 1978 · S/N 38-79A0276 N2330EManhattan Flying Tigers Inc · Bozeman, MTBuilt 1978 · S/N 17271236 N2330JWilliamsburg Air Service Inc · Kingstree, SCBuilt 1979 · S/N T18803455T N2331PGamble Caleb · Rock Hill, SCS/N 38-79A0948 N2332EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271238 N2332YAlbi Aero LLC · Denver, COBuilt 1967 · S/N 17700132 N2333CAfs Inc · Grants Pass, ORBuilt 1978 · S/N R18200152 N2333PHuffman Marshal · Spruce Pine, NCBuilt 1979 · S/N 38-79A0949

Back to AD 80-25-07 R1