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.

N1263SAlabama Law Enforcement Agency · Montgomery, ALBuilt 1976 · S/N 18264831 N12641Wanda Collins Professional Pilot Services LLC · Madisonville, TXS/N 17262136 N12647Mcmahon Dwayne A · Leavenworth, WAS/N 17262142 N12648Aircraft Trade Group LLC · Scandia, MNBuilt 1973 · S/N 17262143 N12649Miller Jacqueline E · Corning, NYBuilt 1973 · S/N 17262144 N1264QYeghikian Sarmen · Glendale, CABuilt 1971 · S/N 15072564 N1264USky Creation Inc · Torrance, CABuilt 1976 · S/N 17266959 N1264YWheeler Charles R · Crown Point, INBuilt 1962 · S/N 15059664 N12650Villegas Guillermo · Scottsdale, AZS/N 17262145 N12651Kelley Aircraft LLC · Weyers Cave, VABuilt 1973 · S/N 17262146 N12653Bryant Jeffrey · Red Bluff, CABuilt 1973 · S/N 17262148 N12655Ker Holdings LLC · Henderson, NVBuilt 1973 · S/N 17262150 N12657Wingsleasing LLC · Wichita, KSBuilt 1973 · S/N 17262152 N1265PElder George · Perryville, MOS/N 15284992 N1265QDumankskii Aviation LLC · Columbus, OHBuilt 1971 · S/N 15072565 N1265SColeman Douglas · Ocean Springs, MSBuilt 1976 · S/N 18264833 N12661Jb Aviation Flight School Inc · Wonder Lake, ILBuilt 1973 · S/N 17262156 N12666Wdr Inc · Grand Forks, NDBuilt 1996 · S/N 20800250 N12668Rebel Aviation Inc · Liberty, MOBuilt 1973 · S/N 17262161 N12669Hedgehoppers Flying Club Inc · Springfield, MOBuilt 1973 · S/N 17262162 N1266MBeta Flight LLC · Queen Creek, AZS/N 33701266 N1266SBarton Jonathan E · Tehachapi, CABuilt 1976 · S/N 18264834 N1266URalstontc LLC · Trophy Club, TXBuilt 1976 · S/N 17266961 N12671Beaver Valley Flying Club Inc · Albion, NEBuilt 1973 · S/N 17262163 N12676Berry Victor A · Ashburnham, MABuilt 1973 · S/N 17262167 N12678Zma LLC · North Little Rock, ARBuilt 1973 · S/N 17262169 N12679Garuda Aviation Inc · Miami, FLBuilt 1973 · S/N 17262170 N1267GChesnut James Scott · Oak Point, TXBuilt 1974 · S/N 310Q1118 N1267QWiltshire Henry C Jr · Plymouth, MABuilt 1971 · S/N 15072567 N1267SWhitmore James W · Grass Valley, CABuilt 1976 · S/N 18264835 N1267USms Aviation Company · Wilmington, DEBuilt 1976 · S/N 17266962 N12682Magish Matthew · Fleming Island, FLBuilt 1973 · S/N 17262172 N12683Sale Reported · Hillsboro, ORSale reported, pending cancellationBuilt 1973 · S/N 17262173 N12684Alvidrez Investments LLC · Lakewood, CABuilt 1974 · S/N 17262174 N12687Davies Kenneth A · Oak Harbor, WABuilt 1973 · S/N 17262177 N1268MHuffer Tyle · Kenansville, NCBuilt 1975 · S/N 18264266 N1268VFuller Joshua · Jackson, WYBuilt 1976 · S/N R1722155 N12692Chouinard Kenneth W Jr · Norton, MABuilt 1973 · S/N 17262181 N12694Dicentes James P · Leicester, MABuilt 1973 · S/N 17262183 N12698American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262187 N1269CNovember 1269 Charlie LLC · East Montpelier, VTBuilt 1979 · S/N 17702693 N1269MEagle High Properties LLC · Calhoun, LABuilt 1975 · S/N 18264267 N1269RThompson Steve E · Port Angeles, WABuilt 1968 · S/N 17700625 N1269SMriaudio Inc · Carlsbad, CAS/N 18264837 N126AKRohl Shirley J · Anchorage, AKBuilt 1957 · S/N 32772 N126BTSecure Storage Solutions LLC · Thomaston, GABuilt 1977 · S/N 4140909 N126DAWhite Drew C · Granbury, TXBuilt 1978 · S/N 17270977 N126ESCobra Aviation Services LLC · Oklahoma City, OKBuilt 2018 · S/N 208B5315 N126JCGebler Laurence W · Ellerbe, NCBuilt 1979 · S/N 18267134 N126KWersinger Duncan · Rochester, NYFirst renewal noticeBuilt 1968 · S/N 17257392

Back to AD 97-01-13