AD 74-18-13
Registered aircraft · 1,642
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:74-18-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:74-18-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:74-18-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:74-18-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.
N4057RCurrier Dustan · Fairbanks, AKN4057W57whiskey LLC · Rowlett, TXN4058RSanders Christopher A · Escondido, CAN4058WBrandon Sidney J III · Dundas, VAN405WBNew England Airlines Inc · Westerly, RIN4061RHorse Saddle Shop Inc · Bremen, INN4064RHissem John T · Castle Rock, CON4065RDever Brandon · Auburn, CAN4065WGrubs Jon P · Winter Haven, FLN4066RMoore Arthur Douglas · Sulphur Springs, TXN4067RM & H Aviation LLC · Homestead, FLN4067WBluestone Land LLC · Charlottesville, VAN40698Murphy Robert H · Skagway, AKN4069WRoss Christian M · Bakersfield, CAN406WBNew England Airlines Inc · Westerly, RIN4070RBamfs Group LLC · Davie, FLN4071RHansen Lindsay Tucker · Las Vegas, NVN4072WBradford Alan R Jr · Ridgecrest, CAN4073RLibby Stephen E · Lincoln, MEN40747Cherokee Flyers LLC · Austin, TXN40758Charlie Six LLC · Mesa, AZN4075RCoastal Airways LLC · Dover, DEN4076RTwk Air LLC · Morgantown, PAN4077RMccollum Aviation Inc · Friendswood, TXN40784High Flying Club Inc · Fort Wayne, INN4078RBrehmer Family Airplane LLC · Knoxville, TNN4080WLance & Company LLC-S · Uniondale, INN4082RMid-Life Crisis Aviation LLC · Renton, WAN4084RLand Aerial Services LLC · Conway, ARN4084WGraham Jessami T · Walsh, CON4085RWojdac David E · Mosinee, WIN40865Fischer William T · Ventura, CAN4086WMorgan Gabriel A Sr · Newport News, VAN4087RWatt Nathan A · Walnut Creek, CAN4088RKako Retreat Center Inc · Russian Mission, AKN408WBNew England Airlines · Westerly, RIN4090RWiebe Aerial Applications LLC · Peabody, KSN40913Matlock Joshua · Squaw Valley, CAN4092RWings Of Eagles LLC · Saline, MIN4092WM & M Aircraft LLC · Lewis Center, OHN40934Southern Style Equipment LLC · Sulphur, LAN4096WCruisers Pacific LLC · Discovery Bay, CAN4098RLawler Christy · Livingston, MTN4099WWilde Stephen · Elverta, CAN40NZGround Effect LLC · Atascadero, CAN40SASemper Fi Aviation LLC · Brooksville, FLN4101RMclean David L · Nashville, TNN4102RDudzinski James · Reno, NVN4102WSkirzynski Eric N · Meridian, IDN4103WBean Sheila L · San Antonio, TX
Back to AD 74-18-13