AD 97-01-13
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
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.
N2261CGandy John W III · Mt Vernon, TXN2261YKemper Dennis R · Carmichael, CAN22628Lemko Dennis A · Fresno, CAN2262TMarsh John E · Washington, DCN2262XStampfler Richard D · Groveland, MAN2262YRegistered aircraftN22638Lindorfer John H · Long Beach, MSN2263CWalker William S · Shallotte, NCN2263JJr Imaging Logistics Inc · Pasco, WAN2263TUnited States Air Force · Dover Afb, DEN2263YMejia Mauricio · South Gate, CAN22645Martinez Emilio · Fairburn, GAN22648Eagles Wings Flight Training · Clintonville, WVN2264GMessner Mark R · Chesapeake, OHN2264JRegistered aircraftAssigned, pending cancellationN22656Berry Frank C · Watkinsville, GAN2265GWilder James S · Eagle, IDN2265YHemann Dale F · Osage, IAN22662Rogers Gary A · Novi, MIN22663Auger Allan Dean · Conifer, CON22667Firkus Lloyd Jason · Plover, WIN2266JRound Engine Aero · Nashville, MIN2266XBarney Julius C · Lutz, FLN22673Merry Robert J · Lynnwood, WAFirst renewal noticeN22676Burgess Barton C · Leesburg, OHN22677Barlow Rod · Kaysville, UTN2267TAeropod Inc · Aurora, CON2267XRound Engine Aero · Nashville, MIN2267YCole Gary L · Richmond, TXN22680Turpen Andrew B · San Andreas, CAN22682Bianchi Brandon J · Castroville, CAN22689Ridge View Aviation LLC · Napanoch, NYN2268CCozach LLC · Wilmington, DEN2268JKing Larry W · Port St John, FLN2268SPlatinum Air Services LLC · Morgantown, WVN22692Hoang Ethan Tai Huu · Metairie, LAN226ACTitle 46 LLC · Hamilton, MTN226BBurton Robert B · New York, NYN226CAChoice Aviation LLC · Hamilton, MTN226DMFewel Lance E · Lake Oswego, ORN226HPRegistration Pending · Valdosta, GARegistration pendingN226JAXin Han Aviation LLC · Atwater, CAN226JTTerrell Jeffrey L · Clear Lake Shores, TXN226WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYN226WTFegert Jeffery · Las Vegas, NVN22702Ryan Good Aviation LLC · Sioux Falls, SDN22706Sego James G · Sequim, WAN22708Arispe Aviation LLC · Mckinney, TXN22709Riggin Flight Service Inc · Madison, SDN2270JFeland Wade · Antler, ND
Back to AD 97-01-13