AD 2016-01-01
Registered aircraft · 412
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:2016-01-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-01-01')
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:2016-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-01-01') 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.
N53ALMsa Pinnacle LLC · Bentleyville, OHN53KBHiers Properties Of Delaware LLC · Chattanooga, TNN53PKSpantech LLC · Glasgow, KYN54199Key Aviation Group LLC · Meridian, MSN541NDBig Sky Flight LLC · Helena, MTN546MAWilliams Joel A · Rocky Face, GAN54RGRemc Leasing LLC · Bismarck, NDN550CRCwr Holdings LLC · Wilmington, DEN555AUInternational Air Services Inc Trustee · Carson City, NVN555GPPlane Intentions LLC · Lobelville, TNN556BATvpx Ars Inc Trustee · North Salt Lake, UTN55ZGDixie Painting & Sandblasting Inc · Northport, ALN560HPRjc Rental Properties LLC · San Diego, CAN562DCPresent Course Investments LLC · Coronado, CAN562HPAir Agco LLC · Bell City, MON565CHensley Tyler Shea · Fayetteville, NCN565HPLindstrom Troy D · Crossville, TNN566MA814 Cartmell LLC · Dover, DEN568HPCkinchen Enterprises LLC · Spring, TXN575CATmofly LLC · Suffolk, VAN577HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN577KC1906 Aviation LLC · Greenwood, SCN57ATJp Bcbnz Holdings LLC · Clinton, MDN587DFTardis Leasing LLC · Fort Myers, FLN58BTValiair Lc Trustee · Casper, WYN59WFLes Chardons Inc Trustee · Wilmington, DEN5PPVerplowens Aviation LLC · Steamboat Springs, CON600KSPlane Fun Inc Tr Trustee · Snellville, GAN601RHN601rh LLC · Helena, MTN606WCFlight Unlimited LLC · Smyrna, GAN6072JSky West Aviation Inc Trustee · Albuquerque, NMN6074JFive Miles Up LLC · Sisters, ORN6077QTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN607MAAllen Kelvin T Trustee · Canyon, TXN6081ERegistered aircraftN6101GPack Aviation LLC · San Jose, CAN6105DLankenau John · Lake Havasu City, AZN611AKConverse Richard L Jr · Durango, CON615WASanderson Aviation2 LLC · Flower Mound, TXN618MAAir Matrix LLC · Lomita, CAN618STT Spare Leasing LLC · Waldo, OHN619TKRegistered aircraftN61KPFlying Coyote Productions LLC · Oro Valley, AZN621NHorizon Aviation LLC · Kalispell, MTN623DTaylor Steve B · Albuquerque, NMN623FGDyeraviation LLC · College Station, TXN62LTLima Tango LLC · Mariposa, CAN634STDc Skies LLC · Pasadena, CAN63SEG B Aerial Applications Inc · Slaton, TXN64AAProspect Aviation Montana LLC · Missoula, MT
Back to AD 2016-01-01