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.
N2171ZMcmillan Seth W · Fairbanks, AKN21725Optic Air LLC · Sioux Center, IAN2172FAndres James E · Delaware, OHN2172QLehr Kenneth Edward Trustee · Sacramento, CAN2172RMitchell Gary · Huntsville, TXN2172YRegistered aircraftN21732Air Puerto Rico Corp · Aguadilla, PRN2173GGrizzly Air Service Inc · Paris, TXN2173RRegistered aircraftN2173YLowe Body And Glass Inc · Asheboro, NCN21741Boniek Martin J · Glennallen, AKN21743Childers Brian L · Edgemont, SDN21745Bellingham Aviation Services LLC · Bellingham, WAN21747N21747 Lc · Wichita, KSN2174QRothrock Brandon E · Los Angeles, CAN2174YJohnson Fred A · Five Points, ALN21754Sale Reported · Kalispell, MTSale reportedN21757Olson Terry L · Rapid City, SDN2175GStem John T · Marlin, TXN2175RHolt Kristopher T · Wichita, KSN21764Blue Sky Flyers Inc · Evans, CON21769Overseas Aviation Inc · Wilmington, DEN2176CScrap Materials Inc · Huntington, ARN2176FClaw Aviation LLC · Missoula, MTN2176GWhite Robert G · Damascus, ORN2176QHawkins George W IV · Kansas City, KSN2176YFischer James H · Wisconsin Rapids, WIN21774Miller William A · Wallkill, NYN2177CRenaissance General Restoration Contracting · Madera, CAN2177GSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2177RCalongne Michelle H · Cypress, TXN2177SFerkin Planes LLC · Caldwell, IDN2177YNewbary Jason W · Missoula, MTN21785Dibiaso Thomas F · Mount Laurel, NJN2178CHowey Paul W · Stevensville, MDN2178R2178 Romeo LLC · Pawlet, VTN2178SAbbey Alyssa · Novato, CAN21791Colson Kevin A · Andover, KSN21799Brownell John P Jr · Prattville, ALN2179FKingdom Air Corps Inc · Sutton, AKN2179GAdonai International Ministries · Marine, ILN2179QHuston Jeffrey D · Haslet, TXN217AFSouth 40th Rentals LLC · Jamul, CAN217AMSeven Alpha Mike LLC · Fredericksburg, TXN217CCWhite Hildery P Jr · Glendale, AZN217JAFlying Colors Airparts Inc · Leesburg, FLN217JLGallup Shelley P · Monterey, CAN217MMiles Manderson L · Lewiston, IDN217MEAir Research Ca Inc · Torrance, CAN21804Sharpe Alexander F · Camarillo, CA
Back to AD 97-01-13