Skip to content

Registered aircraft · 25,368

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.

N9350VSprunk Stephen · Anderson, OHBuilt 1969 · S/N 700010 N9351DJennings David M · Huffman, TXBuilt 1982 · S/N 172RG1130 N9351HBrown Daniel Thomas · Layton, UTS/N 17266109 N9351MKempa Jesse R · Santa Cruz, CABuilt 1966 · S/N 1253 N9351TBenson Michael W · Julesburg, COBuilt 1978 · S/N 38-78A0063 N9351VCaldararu Andrei H · Madison, WIBuilt 1969 · S/N 700008 N93526Delta State University · Cleveland, MSBuilt 1982 · S/N 15285507 N93529Richmor Aviation Inc · Hudson, NYBuilt 1982 · S/N 15285510 N9353DRegistration Pending · Simi Valley, CARegistration pending, canceledBuilt 1982 · S/N 172RG1131 N9353MBarnett Zachary P · Paducah, KYBuilt 1966 · S/N 1285 N9353RStephanian Erick Trustee · Naples, FLFirst renewal noticeBuilt 1978 · S/N R18200695 N9353VLangholz Denise M · Covington, WABuilt 1969 · S/N 700011 N9353YKovax Aviation LLC · Youngstown, OHBuilt 1981 · S/N 21064482 N9354MFresh Air Properties LLC · Hayesville, NCBuilt 1966 · S/N 1286 N9354TJb Aero LLC · Fairview, PABuilt 1980 · S/N 24-1065 N9354VPinckney Robert L · Elgin, SCBuilt 1969 · S/N 700009 N93550Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1982 · S/N 15285513 N9355RSkyline Aviation LLC · Lewistown, MTBuilt 1975 · S/N 18802254T N9356HQuad Cities Aero LLC · Bettendorf, IABuilt 1975 · S/N 17266113 N9356MRegistered aircraftBuilt 1966 · S/N 1288 N9356RQuality By Design Inc · Leesburg, FLBuilt 1978 · S/N R18200696 N9356VWilson Willard L · Daphne, ALBuilt 1969 · S/N 700009 N9356YParsons Bruce W Trustee · Costa Mesa, CABuilt 1981 · S/N 21064483 N9357MSpencer Jared · Mandeville, LABuilt 1966 · S/N 1289 N9357VWise Christopher J · Plano, TXBuilt 1969 · S/N 700013 N93585Sipher William M · Baker, FLBuilt 1982 · S/N 15285521 N9358ELechmanski Philip J · Shelter Island, NYBuilt 1979 · S/N 17272236 N9358LUnited States Air Force · Eglin Afb, FLBuilt 1986 · S/N 17276546 N9358TPitts Lynn Larry · Webb City, MOBuilt 1978 · S/N 38-78A0066 N9358VEickman Jaret · Scottsdale, AZBuilt 1969 · S/N 700014 N93590G & M Aircraft Inc · Wheat Ridge, COS/N 15285524 N9359HWarren Flying Club · Troy, MIBuilt 1975 · S/N 17266115 N9359MStrohacker Louis W · Kerrville, TXS/N 1291 N935PTTailspin Tommys Inc · Port Townsend, WABuilt 1974 · S/N 17263040 N9360RWaggener Chris E · Clyde, NCBuilt 1978 · S/N R18200697 N9360VHarvey John S · Garland, TXBuilt 1970 · S/N 700070 N9361MR&D Mooney Inc · Osprey, FLBuilt 1966 · S/N 1293 N9361VDanson Corp · Henderson, NVBuilt 1969 · S/N 700015 N93621Sunrise Aviation · Ormond Beach, FLBuilt 1982 · S/N 15285527 N9362VYoon Philip K O · El Cajon, CABuilt 1969 · S/N 700011 N9363MBaas John M · Rapid City, SDS/N 1295 N9363VEye Squared Holdings Inc · Houston, TXBuilt 1969 · S/N 700011 N9364MShelton Douglas S · Kingsville, MDBuilt 1966 · S/N 1296 N9365HAugusta Aviation Inc · Agusta, GABuilt 1975 · S/N 17266118 N9366HPowell Jonathan L · Violet Hill, ARS/N 17266119 N9366MHouse Oscar · Wakefield, RIS/N 1298 N9367DMccreery Aviation Co Inc · Mcallen, TXBuilt 1983 · S/N 172RG1139 N9367HDeralex Airways LLC · Miami, FLBuilt 1975 · S/N 17266120 N9367MGriffith Jason R · Guyton, GABuilt 1966 · S/N 1299 N9367VKolisnyk Christopher D · Winterville, GABuilt 1980 · S/N 24-1066

Back to AD 80-25-07 R1