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.
N291SPBarr Air Patrol LLC · Mesquite, TXN291YASherman Jason Bradley · Indianola, IAN29204Jms Aviation LLC · Waynesville, OHN29209Bas Part Sales LLC · Greeley, CON2920GStevenson Taylor A · Dallas, TXN2920JRegistration Pending · Powell Butte, ORRegistration pendingN2920KBowen Kenneth W · Bainbridge Island, WAN2920SLea Nathanael E · Olalla, WAN2920UOtto Mark A · Ludington, MIN2920VMorrow William M Jr · Harrison, IDN2920YApplegate Susan P · Decatur, TXN29210Hawkes Brian R · Hamilton, MTN29217Dawson Adam J · Eveleth, MNN2921AStanford Jeffrey S · Anchorage, AKN2921CMensink David L · Preston, MNN2921JAndrews University · Berrien Springs, MIN29221King Management Systems Inc · Liverpool, TXN29224Phelan Ricky Ray · Jefferson, ORN2922AFowler Kenneth Russell · Locust Fork, ALN2922FKalil Joseph J Jr · Morgan, UTN2922JStecklein Brittney R · Overland Park, KSN2922SWard Aviation · Marysville, OHN29239Gibson Aviation Services LLC · Hudson, WIN2923AWicklander Richard O · Spanaway, WAN2923KSallee Daniel C · Port Angeles, WAN2923SHamann John · Orlando, FLN2923UWeber James · Fall Creek, WIN2923YS & R Aviation Inc · Boise, IDN2924ABennett Ross D · Anchorage, AKN2924FReese Howard Aviation LLC · Anderson, SCN2924JPiscoya Thomas G · Anchorage, AKN2924XAllen Thomas L · Cedar Rapids, IAN2924YLilcad Diversified LLC · Holly Pond, ALN29251Southeast Aviation Services Inc · Hattiesburg, MSN2925AVan Der Molen Baron J · Readstown, WIN2925CElla Butte Farming Co · Ione, ORN2925FRegistered aircraftAssigned, pending cancellationN2925SSmolik Amanda · Ponder, TXN2925VCortese Thomas J · Sedona, AZN2925XPerry Albert D · Houston, TXFirst renewal noticeN2925YTrinity Air LLC · Lewes, DEN2926SFord John M · Rock Stream, NYN2926WSessoms Keith V · Seagrove, NCN2926YViramontes Gilbert A · Temple City, CAN29278Pancho Moreno Y La Flaca LLC · Camuy, PRN2927ESchafer Thomas Charles · Caledonia, MON2927UCarlson Brent A · Medford, ORN2927YReynolds Nathan W Jr · Piedmont, SCN29286Wawro Christopher · East Troy, WIN29289Disarro Wayne · Wasilla, AK
Back to AD 97-01-13