Skip to content

Registered aircraft · 54,837

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-13') 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-13') 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-13')
    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-13')
  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-13')
  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-13')
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.

N12097Aerolease Aviation Rental LLC · Cartersville, GABuilt 1973 · S/N 17261807 N12098Traywick James D · Cope, SCBuilt 1973 · S/N 17261808 N1209MShook Steve Trustee · Boulder, COBuilt 1975 · S/N 18264243 N120BCHunyadi James W · Toledo, OHBuilt 1979 · S/N P21000404 N120DHHiester Donald J · Sicklerville, NJBuilt 1961 · S/N 17248694 N120HAAstley Mark C · Wayne, NJBuilt 1977 · S/N 340A0295 N120JHC&C Cessna LLC · Baltimore, MDBuilt 1977 · S/N U20603636 N120PCHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0079 N120SSSoutheastern Oklahoma State University · Durant, OKBuilt 1976 · S/N 15078900 N12100Tita LLC · Fajardo, PRBuilt 1973 · S/N 17261810 N12104Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261812 N12105N12105 LLC · Tavares, FLBuilt 1973 · S/N 17261813 N12110Port Townsend Air LLC · Puyallup, WAFirst renewal noticeBuilt 1973 · S/N 17261815 N12113Arlins Aircraft Service Inc · Belgrade, MTBuilt 1973 · S/N 17261817 N12115Jones Kenneth A · Mogadore, OHBuilt 1973 · S/N 17261818 N1211FGarner Greg A · Renton, WABuilt 1975 · S/N 18502774 N1211YEdens William D · Mesa, AZBuilt 1962 · S/N 15059611 N12123Aerospatial LLC · Selah, WABuilt 1973 · S/N 17261822 N12128Temme Robert E · West End, NCBuilt 1973 · S/N 17261826 N12129Champagne Patrick D · San Angelo, TXBuilt 1973 · S/N 17261827 N1212MVondullen Ken A · Laplace, LABuilt 1970 · S/N 17259412 N1212USun Country Aero Club Inc · The Villages, FLBuilt 1976 · S/N 17266909 N1212YKennedy Kevin · Vassar, KSBuilt 1962 · S/N 15059612 N12133Skoog Kurtis · Glennallen, AKBuilt 1973 · S/N 17261831 N12138Falcon Air LLC · Anchorage, AKBuilt 1973 · S/N 17261835 N1213FFlight Answers LLC · Miami Lakes, FLBuilt 1979 · S/N 17272972 N1213LBlack Jesse M Jr · Gainesville, GABuilt 1969 · S/N 18259551 N1213RMorgan Robert · Ozark, MOFirst renewal noticeBuilt 1967 · S/N 15064627 N1213SWright Caravan LLC · Seattle, WABuilt 1995 · S/N 20800243 N1213YRistau Ronald R · Lu Verne, IABuilt 1962 · S/N 15059613 N12141Aircraft Management Services Inc · Milton, FLS/N 17261837 N12147Carstens Sandra A · Cary, NCBuilt 1973 · S/N 17261842 N12148Railing Terry L · Lake Mills, WIBuilt 1973 · S/N 17261843 N1214G9791m LLC · Tacoma, WABuilt 1975 · S/N 414-0652 N1214QTalapanuri Gokul N · Austin, TXBuilt 1971 · S/N 15072514 N1214UThomas William R · Eyota, MNBuilt 1976 · S/N 17266911 N12150Baker Daniel Ray · Jacksonville, FLBuilt 1973 · S/N 17261845 N12153Wertz Richard L · Huron, SDBuilt 1973 · S/N 17261848 N12155International Air Services Inc Trustee · Carson City, NVBuilt 1996 · S/N 208B0562 N1215UCarbon Six LLC · San Diego, CAS/N 17266912 N1215YGill Robert S · Anchorage, AKS/N 15059615 N12161Cessna 12161 LLC · Santa Rosa, CABuilt 1973 · S/N 17261851 N12168Boardman Thomas M · Greenwich, NYBuilt 1973 · S/N 17261855 N12169Hammond Donald L · Palmer, AKS/N 17261856 N1216GNeel Aviation LLC · Lakeland, FLS/N 414-0653 N1216MHayward Flying Club · Hayward, CABuilt 1975 · S/N 18264245 N1216VKingdom Air Corps Inc · Sutton, AKBuilt 1976 · S/N R1722143 N1217070 Leasing LLC · Englewood, COBuilt 1973 · S/N 17261857 N12176Cardinal Wings Aviation LLC · Buckner, KYBuilt 1973 · S/N 17261860 N1217FUnited States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502779

Back to AD 97-01-13