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.
N2246JMcmurray Jay C · Niota, TNN2246YHixon Craig D · Sayre, OKN22475Ace Aeromotive Inc · Miami, FLN22477Ray Erin N · Manor, TXFirst renewal noticeN22479Robinson Paul C · San Francisco, CAN2247JHeathers Houses Foundation Inc · Fort Lauderdale, FLN22484Tinoco Joseph I · Shoreline, WAN22487Skyguard Instruction LLC · Ann Arbor, MIN22488Oneal Sean M · Santa Cruz, CAN22489Sky Walker Flight School LLC · Adrian, MIN2248YDavis Christopher S · Halls, TNN22491Yasumiishi Joy Marie Trustee · Juneau, AKN22498Evans Thomas G · Dawson, ALN22499Johnson Dale B · Steele, NDN2249CHepburn Joseph · Towanda, KSN2249EJones Jason Parker · Fayetteville, GAN2249GDelph Timothy M · Wasilla, AKN2249YBlake Bernie E · Troy, NCN224ACSellers Scott R Trustee · Racine, WIN224ALAirborne Support Group LLC · Marion, MTN224CHMadden Jeffrey M · Queensbury, NYN224HThompson Dennis P · Spokane Valley, WAN224JAWingsleasing LLC · Wichita, KSN224MBBarker Ballard M · Satellite Beach, FLN224MHFeely Daniel R · Pasadena, CAN224PTLee Mark W · Blaine, MNN22501Smith Dylan Lane · Oklahoma City, OKN2250EDover Afb Aero Club · Dover Afb, DEN2250JLuce Frederick M · Brookshire, TXN22515Wheeler Bret · La Grande, ORN2251GValentine Terence S · Glennallen, AKN2251TGardner Bryan T · Rancho Cucamonga, CAN22523Beene Donald L · Westfield, INN22526Staloff Jason A · Greenfield, MAN22528Hhd Aviation LLC · Hamilton, OHN22529Rhodes Stephen D · Hendersonville, NCN2252CMickey Donald J · Albuquerque, NMN2252GRutter Eric R · Anchorage, AKN2252TRegistration Pending · Hayward, WIRegistration pending, pending cancellationN2252YMeisch Robert L · Crystal, MNN22533Regner Mark W · Danbury, CTN22536Reep Jennifer B · Stone Mountain, GAN22537Ernst Albert S III · Buda, TXN2253CFoss David K · Anchorage, AKN2253YAviation 2000 Inc · Fort Mill, SCN22540Mcgovern Thomas F · Blue Springs, MON22542Apgyn And Associates Inc · Coral Springs, FLN22544N1705r Inc · Cobb, CAN2254CCook Charles Nicholas · Lakeside, TXN2254FHudson Daryl J · Redwood Valley, CA
Back to AD 97-01-13