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.
N2554LAirheads Inc · Charles Town, WVN2554RBartlett Richard H · Sussex, NJN2554SHanan Roy T · Edgewater, FLN2554UMustang Ops LLC · Orem, UTN2554ZClement L Ross · Anchorage, AKN25557All Aviation Xp LLC · Parkland, FLN2555JRabenaldt Gilbert P · Telferner, TXRegistration revokedN2555LGates Kimberly B · Kintnersville, PAN2555UBurull Donald E · Wichita, KSN25564Sunrise Aviation Inc · Ormond Beach, FLN25567Ellingwood Kevin J · Williamstown, MAN2556KCarlson Steven J · Fairbanks, AKN2556YZeafla Randall R · Elizabethtown, KYN25572Gruetzmacher Marcus Darren · Goliad, TXN25573Adjoodani Farhad F · Glen Burnie, MDN25575Pierce John S · Delevan, NYN2557JSale Reported · Lake Havasu City, AZSale reported, canceledN2557LSparks Ryan J · Peculiar, MON2557RWhite Willis W · Boise, IDN2557SAgri-Flight LLC · Waterford, MIN2557UWings Of Hope · Chesterfield, MON2557YSaddle Mountain LLC · Cave Creek, AZN25582Heavy Metal Air LLC · Farmingdale, NYN2558GScolari Shawn Fenton · Meeteetse, WYN2558JHay Douglas E · Anza, CAN2558LHoecher Robert · Anchorage, AKN2558RKahn Steven P · Boise, IDN2558UDelany Patrick J · Marion, TXN2559JStuder Alfred C · Shelby, MIN2559LFlying Circus LLC · Bridgeport, WVN2559QJordan Valley Aviation LLC · Jordan Valley, ORN2559USnake River Flying Club LLC · Horseshoe Bend, IDN2559YA & D Precision Machining Inc · Fremont, CAN255EWollak John M · Mount Vernon, WAN255KRAvra Valley Flyers LLC · Gilbert, AZN255WFKlapmeier Alan L · Iron River, WIN25604Aerospace Trust Management LLC Trustee · Wilmington, DEN25608Smith Boyd · Goshen, INN2560GJackson Air LLC · Temecula, CAN2560JSmith Douglas J · Sidney, OHN2560USpangenberg Daniel M · Greenville, MIN25610Painter Bryan · Renton, WAN2561QMariposa Aviation Inc · East Wenatchee, WAN2561RHeber Valley Flying Club · Park City, UTN2561UNeinast Jeffrey J · Olton, TXN2562LWilkey Paul W · Sullivan, INN2562QStiles Thomas W · Pocahontas, ILN2562RKehler Grain & Livestock · Saint Xavier, MTN2563JKrebs Charles · Suwannee, FLFirst renewal noticeN2563SClements Kenneth Brian · Las Vegas, NV
Back to AD 97-01-13