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.
N185VHGreen Daniel H · Eagle River, AKN185VKPoint Two Mmo Aviation · Lake Stevens, WAN185VMGardner Marvin L II · Addison, TXN185VPSongbird Aviation Services LLC · Wilmington, DEN185VVJetran LLC · Horseshoe Bay, TXN185WZeiger William O Jr · Bend, ORN185WAEverel Floatplane LLC · Sandia Park, NMN185WBFodor Scott M · Barryton, MIN185WCSindelir Randall L · Columbia Falls, MTN185WFLewis Clyde · Anchorage, AKN185WGPioneer General Engineering Inc · Fallon, NVN185WKIntrepid Air LLC · Palmer, AKN185WMWithrotor Aviation Inc · Lakeview, ORN185WPArrowhead Holdings Inc · Wilmington, DEN185WRNorthwoods Aviation Inc · Cadillac, MIN185WSStotlar William B · Pinckneyville, ILN185WTPenley Robert G · Corinth, TXN185WVScenic Air LLC · Kalispell, MTN185WWWright John M · Bellevue, IDN185WXChew Scott E · Estes Park, CON185WYBrantner Brian P · Spokane Valley, WAN185WZB H Hildebrand Construction Inc · Cataldo, IDN185XSouthern Aircraft Consultancy Inc Trustee · Casper, WYN185XLBryant Theodore M · Wasilla, AKN185XSJepsen John S · Anchorage, AKN185XVN185xv LLC · Austin, TXN185YLee Bryan D · Rexburg, IDFirst renewal noticeN185YHMcdaniel Robert M · Tonasket, WAN185YMBarber Michael E · Prescott Valley, AZN185YTSutton Aircraft Salvage LLC · Palmer, AKN185YVCul-Aircorp Inc · Wellington, FLN185YYDagostino Thomas J · Wasilla, AKN185ZWab Air LLC · Butte, MTN185ZAPlane Fun Inc Tr Trustee · Snellville, GAN185ZMRegistered aircraftN185ZZLeading Edge LLC · Scottsdale, AZN18602Poston James M · Hixson, TNN1860YPeterson Jerad · Oshkosh, NEN18612Missoula Fliers LLC · Milltown, MTN18618Hammons Bryan S · Stephenville, TXN1861XCabreja Sanchez Elmer · Carolina, PRN1861ZPadden Geary L · Duluth, MNN18623Fleischmann Fred · Racine, WIN18627Oberhansly Lucas C · Roy, WAN18628Paul William A · Windfall, INN1862QB & P Transportation LLC · Mount Blanchard, OHN1862XCose Gary D · Livermore, CAN1862YVakalis Kevin A · Chugiak, AKN18630Gaddy Tyler Quintin · Advance, NCN18634Bagge William J · East Longmeadow, MA
Back to AD 97-01-13