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.
N3158SBr Aviation LLC · Lewes, DEN3159EDinaland Aviation · Vernal, UTN3159FYarbrough Chad · Bloomingdale, GAN3159JIcaro Flight Club Of Miami Inc · Miami, FLN3159RSdmg Signs LLC · Las Vegas, NVN3159TLown Alfred L · Elkhorn, NEN315AGAlpert Adam L · Delray Beach, FLN315LAZalen LLC · Mercer Island, WAN315MDuckwing LLC · Reno, NVN315MTFly Mt Llp · Charlo, MTN315PKGardisser Dennis R · Lonoke, ARN315TMSteadman Tony L · Arlington, TXN3160LKo Hee Sun · Norwood, NJN3160STronier Paul C · Sparks, NVN3160VPoteet Eddie · Corsicana, TXN3161CFinzer Melvern K · Naperville, ILN3161RDeertrack Aviation LLC · Oshkosh, WIN3161SKrikorian John R · Fresno, CAN3161YSleepy Cat Mountain Real Estate Co · Meeker, CON3162DMarks Daniel A · Portersville, PAN3162FSkinner Roma L · Ovilla, TXN3162RSky West Aviation Inc Trustee · Albuquerque, NMN3162SEagle Aircraft LLC · Park City, UTN3162USchreiber Charles R · Calexico, CAN3162XSchilling Mark F · Clear Lake, SDN3162YRogers Anthony L · Monrovia, CAN3163FSchwab Roscoe C III · De Kalb, TXN3163SLabrum Andrew K · Boise, IDN3163VZak Enterprises LLC · Cortez, CON3164DCallahan Robert D · Mesa, AZN3164QHanson Donald R Jr · Hillsboro, NDN3164TOverflight LLC · Harahan, LAN3164XPeterson Dennis E · Cambridge, MNN3165EJlk Management LLC · Kerrville, TXN3165FFindlay Bruce · Caro, MIN3165QNorris Benjamin · Zolfo Springs, FLN3165RReds Cable Tv Inc · Washington, NCN3165UMetz Martin A · Phoenix, AZN3165YFoster John W · Olathe, KSN3166CPersinger Paul W · Wasilla, AKN3166FShelton K Trustee · Perrysburg, OHN3166RVarnson Dale B · Brocket, NDN3166XDobbelaere Rick H · Oakwood, OHN3167DOrtlip Stephen A · Kenbridge, VAN3167FGreen James C · Cedar Rapids, IAN3167JRay Charlie B DBA Chucks Air Service · Prosser, WAN3167SLightning Bolt Aviation LLC · Bozeman, MTN3168CRegistration Pending · Anchorage, AKRegistration pendingN3168DBovee John W Or · San Diego, CAN3168RRunck Russell E · Watertown, MN
Back to AD 97-01-13