AD 86-13-04 R3
Registered aircraft · 18,497
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:86-13-04-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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.
N125ARJuliet Kilo Air 1 LLC · Paradise Valley, AZN125BEGomez Eliud · Winter Park, FLN125BMBaron Transporation Services LLC · Destrehan, LAN125BRRh22 LLC · Tampa, FLN125CPLinscott Jeffrey R · Boring, ORN125KTRustair Inc · Anchorage, AKN125LCStrike Fund LLC · Peachtree City, GAN125LLDykstra Darren · Pacific Grove, CAN125PCRegistered aircraftN125TR Darrell Weaver Enterprises LLC · Moore, OKN125TCYoung Jeremy · Portland, ORN1261RHuff Joshua A · Larned, KSN1266RObowa James K · Lino Lakes, MNN1267RMurrell James F Sr · Douglas, AZN126ABOxford Systems Inc · Hicksville, NYN126BTSecure Storage Solutions LLC · Thomaston, GAN126GLN126gl LLC · Roca, NEN126HBockman Ltd · Milford, IAN126TKLoftis Chris · Fort Worth, TXN126WGN126wg LLC · Oak Brook, ILN12711Oxman Judith R · Riva, MDN1273SSullivan Stephen G · Mize, MSN1274GSol Aerial Surveys LLC · Las Vegas, NVN1274RPolyspray Corporation · Asheboro, NCN1276VNew Horizon Aviation Inc · Warwick, RIN1279GHodgman Gary W · Greenville, TXN1279RSedona Aviation LLC · Sedona, AZN127BSDemaagd Aviation LLC · Hickory Corners, MIN127BZFox Systems Inc · Calhoun, GAN127DRKlamecki Alan P · Phoenix, AZN127MAVtflyboy LLC · Richmond, VTN127MBBerger Max · Daytona Beach, FLN127SKVoyager Exploration Inc · Marblehead, OHN1280GSky Aviation And Consulting · Panorama City, CAN1284PTwostars Aviation LLC · New York, NYN1285FWill Rittner E · Sevierville, TNN1286FTaylor Aviation Inc · Mazama, WAN1289RLeblanc Rick M · Deerwood, MNN1289UKavak Air Inc · Middletown, DEN128AEChiave Solutions LLC · Orlando, FLN128BRNautilus Aviation LLC · Yadkinville, NCN128MCDawson Aircraft Inc · Clinton, ARN128PFSky West Aviation Inc Trustee · Albuquerque, NMN128TTWarner Wings LLC · Yakima, WAN128WMOac Aviation LLC · Asheville, NCN128WSSkyway Air Taxi LLC · Manassas, VAN1290CPepper & Acorn LLC · Henderson, NVN1292FRustair Inc · Anchorage, AKN1293CTexas Blue Skies Aviation LLC · Canyon Lake, TXN1296AN1296a LLC · Asheville, NC
Back to AD 86-13-04 R3