AD 2016-05-13
Registered aircraft · 3,126
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-05-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:2016-05-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:2016-05-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:2016-05-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.
N813DGBristow LLC · Lake Charles, LAN813EBOld River Flying Service LLC · Helena, ARN8149SIcu.Net Inc · Tulsa, OKN814BCRegistered aircraftN814EBBlair Aviation LLC · Essex, MON814LCN814 LLC · Dover, DEN814RXHog Air Aviation Inc · Paragould, ARN8156ZWings Of Dawn LLC · Valley Center, KSN8158XPatterson Frederick W III · American Canyon, CAN815BABlair Aviation LLC · Essex, MON815CFMeridian Air LLC · New Boston, MIN815RXHog Air Aviation Inc · Paragould, ARN816BPAls Aviation LLC · Westlake Village, CAN816BSN811kc LLC · Sunrise, FLN816GGGoodwin Bryan · Fort Smith, ARN816PAHangtime Investments LLC · Parma, MON816QAOver The Top Aviation Inc · Jonesboro, ARN816SAStott Aerial Spray Inc · Jefferson, IAN817HBoedeker Flying Service East LLC · Childress, TXN817MSCarmarc II LLC · Miami, FLN817RXHog Air Aviation Inc · Paragould, ARN81820Uas Transervices Inc · Boca Raton, FLN818AJC & C Flying Service Inc · Pocahontas, ARN818EBBretts Spray Service Inc · Onida, SDFirst renewal noticeN818FWPelican Aircraft Inc · Wilmington, DEN818JCVogel Engineers Inc · Walnut, CAN818SASak I LLC · Miller, SDN819ACAurora Cooperative Elevator Co · Aurora, NEN819EEVaquero Skies LLC · El Paso, TXN819MHC&W Logistics LLC · Garden City, KSFirst renewal noticeN819SWWho Dey LLC · Savannah, GAN81BLScott Manufacturing LLC · Henderson, KYN81ETRussell Timothy Lee Jr · Saint Petersburg, FLN81SUMedary Aviation LLC · Brookings, SDN820BHVertical Air Inc · Deland, FLN820FEFederal Express Corporation · Memphis, TNN820GMSecond Wind LLC · Tallahassee, FLN820RDImhof Air 2 LLC · Ferndale, WAN821JRegistration Pending · West Branch, MIRegistration pendingN8226ZUas Transervices Inc · Boca Raton, FLN8227PUas Transervices Inc · Boca Raton, FLN822KANeal Aircraft Inc · Slaton, TXN822MMBristow LLC · Lake Charles, LAN822TAN822ta LLC · Kinsley, KSN823EBIdi Aviation LLC · Indianapolis, INN823XTransport Services LLC · Birmingham, ALN8244LAircraft Partner N8244l Dst · Wilmington, DEN825BKKlein Flying Service · Lawrenceville, ILN825BLTailwinds LLC · Houston, TXN825KASav Aviation LLC · Jacksonville, TX
Back to AD 2016-05-13