AD 97-25-01
Registered aircraft · 3,184
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-25-01')
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-25-01')
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-25-01') 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-25-01') 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.
N10NFThompson Benjamin K · Nevada, TXN10QWBlackhawk 04 LLC · Portland, ORN10TBDalks Leasing Inc · Wilmington, DEN10VZBlanco Air Services LLC · Houston, TXN10WPawsitive Rate LLC · Corpus Christi, TXN10WEGear Up Inc · Ramona, CAN10WG10wg LLC · Newman Lake, WAN10XJNext Phase Ia LLC · Las Vegas, NVN1103GMcn-Air LLC · Macon, GAN110BMDrewcy Inc · Wilmington, DEN110ECState Of Tennessee · Nashville, TNN110ELForsyth Technical Community College · Winston Salem, NCN110GGo Soar LLC · Highland Village, TXN110PMCcp Air LLC · Norwalk, OHN1110KPeach Air Corporation · Wilmington, DEN1112BTvpx Trust Co LLC Trustee · North Salt Lake, UTN11141Hoitsma Lynn F · Castlewood, SDN1114KRogers John Stuart Trustee · Hughson, CAN1114ZCarefree Air LLC · San Jose, CAN111AABlue Water Aviation LLC · Vestavia, ALN111CAKingmax Aviation LLC · Miami, FLN111DXRockwood Investments LLC · Calexico, CAN111ENPecos Air Inc · Roswell, NMN111JAMillennium Falcon 2020 LLC Trustee · Wilmington, DEN111KCSherrmore LLC · Winter Park, FLN111MIngram Industries Inc · Nashville, TNN111MQBismarck Air Medical LLC · Bismarck, NDN111MZCrb Companies LLC · Tulsa, OKN111PVHenson Builders LLC · Dallas, TXN111SSFamily Time Machine LLC · Stuart, FLN111TCGrady Excavating Inc · Mukilteo, WAN111WKMad-Con LLC · Ijamsville, MDN111XLNova Aircraft Inc · Clearwater, FLN1126JBbc Air LLC · Macon, GAN112HGAlghazzawi Hani · Toledo, OHN1130JN1130j LLC · Huntsville, TXN113SHHill Lawrence E · Marion, MTN114CWMatagorda Production Co · Houston, TXN114HBEaglemed LLC · Wichita, KSN114PJRowe John J · Kansas City, MON1153SThomas Michael R · Saint Clair, MON1155TCaljet Aviation LLC · Magnolia, TXN115CTChastang Lawrence · Orlando, FLN115HDepartment Of Homeland Security · Washington, DCN115TTNo Delay LLC · Tickfaw, LAN115YSTunnell Darrell · Visalia, CAN11638N3701d LLC · Wilmington, NCN1167ADakota Wings Of Delaware LLC · Sioux Falls, SDN11692Vertical Transit Corp · Luling, TXN116DGStructures Inc · Mesa, AZ
Back to AD 97-25-01