AD 2003-26-06
Registered aircraft · 1,564
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:2003-26-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-26-06')
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:2003-26-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-26-06') 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.
N20EUWerking John William III · New Windsor, MDN20FKJohnston Brian · Bethany Beach, DEN20FQJag Capital LLC · Cocoa, FLN20FRNorton Justin William · Albuquerque, NMN20FVRogers Robert D Jr · Keller, TXN20FZSharp Randy L · Rocklin, CAN20GFVerbil Christopher J Trustee · Los Altos, CAN20GKHashmi Aijaz · Riverside, CAN20GUBaldree Christian Blair · Roseville, CAN20JZWest William D · Newton, NCN20KGAdspitalny LLC · Waynesville, MON20KLBuell Kenneth B · Port Orange, FLN20KMMozur Matthew Allen · Danvers, MAN20KNShaw William C · Carmel, NYN20KPHulsey Ryan A · Cleveland, GAN20LUCamas Wings LLC · Camas, WAN20LVSilver Skyways LLC · Las Cruces, NMN20NBStauffer Michael S · Wichita Falls, TXN20NCJohnson Professional Aviation LLC · League City, TXN20NDSheff Donald · Redwood City, CAN20RFAffinity Air LLC · Fort Worth, TXN20SNHealy Edward · Fort Atkinson, WIN20TBSouthern Aircraft Consultancy Inc Trustee · Casper, WYN20TKVanguard Executive LLC · Elfers, FLN20TLN20tl LLC · Incline Village, NVN20VCDanny J Daigle LLC · Greenville, MEN20VTRegistered aircraftN210CLPark Rapids Avionics Inc · Park Rapids, MNN211GRTribus Aviation LLC · Saint Louis, MON2127SEurotec Vertical Flight Solutions LLC · Eudora, KSN212BWBoerne Flight Options LLC · Wilmington, DEN212MPMp 212 LLC · Charlottesville, VAN213REWhital Enterprises LLC · Dover, DEN214EHBristow LLC · Lake Charles, LAN214GHCobalt Holdings Inc · Pacoima, CAN214GTAcba Inc Trustee · Wilmington, DEN215EHBristow LLC · Lake Charles, LAN216CHCoastal Helicopters Inc · Juneau, AKN216EHBristow LLC · Lake Charles, LAN217DCEasterly Capital LLC · Beverly, MAN217EHBristow LLC · Lake Charles, LAN217FDBristow LLC · Lake Charles, LAN217TMRegistration Pending · Boise, IDRegistration pendingN2188AAircraft Guaranty Corp Trustee · Oklahoma City, OKN218LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN219RTSky West Aviation Inc Trustee · Albuquerque, NMN219SDFreund Gregor · San Francisco, CAN219WEFinnegan Dennis M · Novato, CAN21AJAllcroft Roger A · Haydenville, MAN21ARClarkson Jeffrey D · Park Rapids, MN
Back to AD 2003-26-06