AD 2000-16-05
Registered aircraft · 428
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:2000-16-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-05')
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:2000-16-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-05') 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.
N22730Reynolds Darryl G · Wills Point, TXN232RRPoint Of View Helicopter Services LLC · Bowdoinham, MEN24TPFlying Z Ranch LLC · Douglas, WYN262LHNeo Helicopter Academy LLC · North Royalton, OHN267RWKoelzer Galen G · Othello, WAN269AReynolds Darryl G · Wills Point, TXN269ABSkyline Aviation Inc · San Angelo, TXN269ADU S Aviation Training Solutions Inc · Titusville, FLN269AHUS Aviation Training Solutions Inc · Titusville, FLN269AJSkyline Aviation Inc · San Angelo, TXN269CNN9660f LLC · Grand Ledge, MIN269GLAerospace Trust Management LLC Trustee · Wilmington, DEN269HVertical Development LLC · Birmingham, ALN269HAN269ha LLC · Manassas, VAN269HHCaprock Technical Services Inc · Kempner, TXN269JATeam Aero LLC · Shawnee, KSN269JPBrones Jon P · Blanco, TXN269MDCactus Air Force LLC · Carson City, NVN269MRAgl LLC · Othello, WAN269NInternational Air Services Inc Trustee · Carson City, NVN269SFHarvey Kandace · Snohomish, WAN269SRRaper David A · Mesa, AZN269STSalina Tree Inc · Salina, KSN269TCRegistration Pending · Redmond, WARegistration pending, pending cancellationN269TJSenninger Thomas P · Clermont, FLN269TPPhoenix Leasing LLC · Menomonee Falls, WIN269TTSharmark LLC · Dry Ridge, KYN269VCRegistered aircraftN269VTQualitair LLC Trustee · MichelstadtN271DGMa King LLC · Stanwood, WAN277DTFindlay Enterprises Ltd · Lafayette, INN279SAAll On Black LLC · New Smyrna Beach, FLN292BHelo Operations LLC · Waynesville, MON296CPatriot Marine LLC · New Haven, CTN29PJCastle Farms Inc · Sunnyside, WAN300ARAw Industries LLC · Comanche, TXN300AUSchweizer Rsg LLC · Fort Worth, TXN300BPOpie Aviation Services LLC · Nashville, NCN300DSEllis Thomas Troy · Slidell, LAN300GUSchewizer Rsg LLC · Fort Worth, TXN300NBMcilrath Thor · Arlington, WAN301DTDawson Taylor Enterprises LLC · Dover, DEN301MGWild Blake · Waialua, HIN302HGHarding William Jr · Quinlan, TXN303HGWhirlybirds LLC · Mount Pleasant, SCN305BSAllen Andra L · Gila, NMN3075UEvans Ronald G · Imlay City, MIN308CWHeritage Investment Corp · Arlington, TXN310CPOregon Heli LLC · Bandon, ORN311GBWhirlygig Enterprises LLC · Dover, DE
Back to AD 2000-16-05