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.
N20843St Louis Flying Club Inc · Ellisville, MON20845Clark Bradley D · Kirkwood, ILFirst renewal noticeN2084EBuchholz Steve DBA · Clarkston, MIN2084GFlying Farmers LLC · Hills, MNN2084RTej Builds Air LLC · Winchester, VAN2084XPrier Duncan M · Bonita Springs, FLN2084YRegistration Pending · Monroe, MIRegistration pendingN20852Spaulding Kenneth L · Sahuarita, AZN20854Branson Bonanza Club · Branson, MON20855Mission Aviation LLC · Billings, MTN20856Pointon Martin J · Snohomish, WAN20858Vintage Flyers Inc · Napa, CAN20859Anderas Per R · Green Bay, WIN2085GBackcountry Guys LLC · Prescott, AZN2085XBrian Murray J · Pekin, ILN2085YLima Romeo Kilo Golf Lp · Worthington, INN20862Barrington Aviation LLC · Kalamazoo, MIN20865Agasair LLC · East Hampton, NYN2086GHigh Country Aces LLC · Cove, ARN2086QMillner Paul · Berkeley, CAN2086XPerron Joseph R · Jasper, GAN2086YLewis Mark N · West Plains, MON20870Willis David A · Thief River Falls, MNN20871High Flight Academy LLC · Allison Park, PAN20876Ogalalla Land & Cattle Ltd · Douglas, WYN20877Teton Leasing LLC · Pocatello, IDN2087EPcs Aviation LLC · La Canada, CAN2087FH & M Ltd · Warren, IDN2087GTate Frederic H S DBA · Marfa, TXN2087RMangus Ricky Alan · Kent, WAN2087YEllsworth Matthew R · Fairbanks, AKN2087ZFischer Gary H · Savannah, GAN20882Stuart Roger G Jr · Mount Pleasant, TXN20888Baker Michael A · Watsonville, CAN2088RRegistration Pending · Fort Worth, TXRegistration pendingN2088USimpson Equipment Leasing LLC · Hays, KSN2088YHowell Rebecca Elizabeth · Elgin, TXN20890Thomas Brett · Gettysburg, PAN20891Morristown Flying Service Inc · Talbott, TNN2089ESkyhawk N2089e Ltd · Deerfield, ILN2089QKelly Daniel W · Conway, SCN2089STxt Aviation LLC · Deland, FLN2089XMoravitz Kim J · Turtle Lake, WIN2089YSooter Craig A · Sedgwick, KSN208ABSkydive Guam Inc · Barrigada, GUN208AJCessna 2080711 Inc Trustee · Wilmington, DEN208ATLeciejewski Darrell K · Mc Alpin, FLN208AXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN208BMerlin Labs Inc · Boston, MAN208BABoeing Co · Renton, WA
Back to AD 97-01-13