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.
N3017JColeman John C · Mc Alpin, FLN3017URivera Michael R · Magnolia, TXN3017XMunson Timothy G · Mendota, ILN30182Johnson Arnold R · Mina, SDN30184Cp Aviation Inc · Santa Paula, CAN30189Onguard Aviation LLC · Cottonwood Falls, KSN3018FDietzler James J · Weyauwega, WIN3018JHargraves Richard N · Clarksville, ARN3018QAndre Eric J · Somerset, WIN3018XWard David J · Garden Valley, IDN3018YGranger Airplane LLC · Granger, INN30195Palmer Peter L · Mission, TXN30198Thomas Mark J · Vacaville, CAN3019FMadison Richard Christopher · Little Rock, ARN3019JRhinelander Flying Service Inc · Rhinelander, WIN3019QHatfield Brothers LLC · Gooding, IDN3019XSkyy King LLC · Helena, MTN301ALForhan Michael A · Urbana, OHN301CPWhy Not Fly Aviation LLC · Gainesville, VAN301DBDon Davis Aviation Inc · Henderson, KYN301DDRockalong Holdings LLC · Stanton, TXN301DPEvans Jack · Albuquerque, NMN301GASouthern Aircraft Consultancy Inc Trustee · Casper, WYN301GWCollege Of Missionary Aviation Inc · Keystone Heights, FLN301JCGardner Jeffrey · Reno, NVN301JRTropitech Inc · San Juan, PRN301MCCharles Michael Maya · Erie, CON301NDPutzke Becky A · Fort Ripley, MNN301PFLahm David K · Cozad, NEN301PLCutbirth David B · Monahans, TXN301RS2f Trade LLC · Collinsville, TXN3020UKelly Ho-Montoya Insurance Group LLC · Wichita Falls, TXN3020XLima 2 Aviation Of Mississippi LLC · Bogue Chitto, MSN3020YJ & T Sullivan Farms Gp · Macon, TNN30218Mckillip Kirby G · Kemah, TXN3021EAircraft Solutions LLC · Spokane, WAN3021FRegistered aircraftN3021JDuffy William B · Denton, TXN3021QPicco Anthony · Sykesville, MDN3021SCollett Danny W · Stewart, TNN3021XMay'S Welding Service Inc · Cotulla, TXN3021YBrancao Bryan A · Norco, CAN30225Hall Curtis B · Shepherdsville, KYN3022EBoulais Aaron · Upland, CAN3022SMcnulty Bobby J · Luling, LAN3022VRetroair Restoration LLC · Big Lake, AKN3022XCintim LLC · Carrabelle, FLN30231Pankratz Paul J · Lakeville, MNN30235Booher Harold D · Manchester, MON30238Nunley Dwight · Hawkins, TX
Back to AD 97-01-13