Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N8535YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1696 N8536PBaker Gary J Trustee · Stateline, NVBuilt 1965 · S/N 26-117 N8538PNovo Rafael E · Edgewood, NMBuilt 1965 · S/N 26-119 N8538YRothstein Steven R · Punta Gorda, FLBuilt 1967 · S/N 30-1606 N8539YTwinco Leasing LLC · Yacolt, WABuilt 1967 · S/N 30-1626 N853BTParadigm Aviation LLC · Sioux Falls, SDS/N 28R-7703076 N8540FMckenney Charles W · Mount Ida, ARBuilt 1976 · S/N 32R-7780108 N8540YCli Aerospace LLC · Appleton, WIS/N 30-1568 N8542PPro Aviation LLC · Allen, TXS/N 26-123 N8542YAviation Training Solutions LLC · Hilo, HIBuilt 1967 · S/N 30-1598 N8544PSetzler Frank · Gilbert, AZBuilt 1964 · S/N 24-4001 N8546FBarts Flying Service Inc · Storm Lake, IABuilt 1976 · S/N 32R-7780109 N8547FPage Elton T III · Cotulla, TXBuilt 1976 · S/N 34-7770090 N8547PStewart James David · Mesa, AZBuilt 1964 · S/N 24-4004 N8549PWest Texas Weather Modification Association · San Angelo, TXBuilt 1964 · S/N 24-4006 N8550PNick Smith And Associates Inc · Mcallen, TXBuilt 1964 · S/N 24-4007 N8551PBratcher Troy L · Williston, NDS/N 24-4008 N8555YScharf Mark T · Rosamond, CAFirst renewal noticeBuilt 1968 · S/N 30-1702 N8556PLandis Ehrin · Redding, CABuilt 1964 · S/N 24-4013 N8557PQuaal Ranch Inc · Sundance, WYS/N 24-4014 N8558CDan & Jerrys Greenhouse LLC · Monticello, MNBuilt 1976 · S/N 34-7670148 N8558PBaughman Kevin R · Avinger, TXBuilt 1964 · S/N 24-4015 N8558YFritsch Nathaniel · Ettrick, WIBuilt 1968 · S/N 30-1705 N8559PMcclean Adam D · Lakeport, CABuilt 1964 · S/N 24-4016 N8560YSullian John J · Alexandria, VAS/N 30-1707 N8562PRegistration Pending · Waukee, IARegistration pendingBuilt 1965 · S/N 24-4019 N8564NEby Leo V · Clearville, PAS/N 28R-7135112 N8564YGingers Holdings Inc · Jacksonville, FLBuilt 1968 · S/N 30-1711 N8565PLynn Owen P · Vinemont, ALS/N 24-4021 N8566PRicciardi Brian · Dennis, MABuilt 1964 · S/N 24-4022 N8566YClarke George W III · Sierra Vista, AZBuilt 1968 · S/N 30-1714 N8567PJeewek Rita M Trustee · Parma, OHBuilt 1964 · S/N 24-4023 N8567YJohnson Randy D · Becket, MAS/N 30-1715 N8569PPurpose Flight Inc · Wilmington, DES/N 24-4026 N8571PBrackett William E · Capitan, NMBuilt 1964 · S/N 24-4028 N8572PService Drug DBA · Chadron, NEBuilt 1964 · S/N 24-4029 N8573PMounicou Sonny M · Olive Branch, MSBuilt 1964 · S/N 24-4030 N8577PPrice Isaac H · Flat Rock, ALBuilt 1964 · S/N 24-4034 N8578PGibbs Gregory Curtis · Engelhard, NCBuilt 1964 · S/N 24-4035 N8579PWor LLC · Jamaica Beach, TXBuilt 1964 · S/N 24-4036 N8582CCurran Aviation Services LLC · Yorba Linda, CABuilt 1976 · S/N 28R-7635166 N8582MSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844160 N8582PSchwalbach Russell R · Bondurant, IABuilt 1964 · S/N 24-4039 N8583NSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844161 N8583PLl Aviation LLC · Kansas City, MOBuilt 1964 · S/N 24-4040 N8583YGray Michael W · Cheyenne, WYBuilt 1968 · S/N 30-1736 N8584PHackens Donald G · New Underwood, SDBuilt 1964 · S/N 24-4041 N8584TSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844162 N8585PNelson Christopher A · Silver Spring, MDBuilt 1964 · S/N 24-4042 N8585YGospel Ministeries International Inc · Mc Donald, TNBuilt 1968 · S/N 30-1738

Back to AD 97-01-01 R1