AD 2016-08-18
Registered aircraft · 399
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-08-18')
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-08-18')
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-08-18') 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-08-18') 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.
N315AKAlsworth Glen R Sr · Port Alsworth, AKN316AKKuspuk School District · Aniak, AKN316HABidzy To Hot Aana Corp · Dillingham, AKN317AKSafeco Leasing LLC · Port Alsworth, AKN31932Air Cargo Solutions Inc · Two Rivers, AKN31CRStory Aranzazu · Draper, UTN31NWAlpha Whiskey 2 LLC · Brandon, MSN31PRAlpha Whiskey 1 LLC · Brandon, MSN31RDIsland Bound LLC · Dunedin, FLN31TEMiller David A · Albany, ORN321SJTmg Aircraft Holdings LLC · New Port Richey, FLN323APEm Concordia Inc · Brooklyn, NYN323DDHd Security Systems LLC · Watertown, TNN333EJCentral Virginia Aviation Inc · North Dinwiddie, VAN333HFValiair Lc Trustee · Casper, WYN333PRGriffin Wings LLC · Lithia, FLN334RPRegistration Pending · Seneca, SCRegistration pendingN33URAthena Aviation LLC · Golden, MSN341CACovenant Air LLC · Wilmington, DEN348GGFlplanes 21 Of Miami LLC · Miami, FLN34WM70 North LLC · Anchorage, AKN350CYMowotech Inc · Boca Raton, FLN350DTDestination Alaska Air Service LLC · Homer, AKN350FMF M Aero Inc · Calhoun, GAN350GBCarto-Flight · Willoughby, OHN350KCLegare Aviation LLC · Murrells Inlet, SCN350LUValiair Limited Co Trustee · Casper, WYN3516AAirplane 2 LLC · Sedona, AZN3523DQuick Gas Aviation LLC · Thomasville, GAN3523YL A B Flying Service Inc · Renton, WAN35269Marlin Aviation Inc · West Palm Beach, FLN3527DKlockenga Matthew · Crystal Lake, ILN3527UWarbelows Air Ventures Inc · Fairbanks, AKN3529AMajestic Enterprises Ltd · Wilmington, DEN3529WMission Flight · El Monte, CAN3535SEj Hodgson Aviation Inc · Beaver Island, MIN3536BBering Capital LLC · Anchorage, AKN353SLSneaker Air Inc · Miami, FLN35475Abd Corporation Inc · Tinian, MPN3547BMlmce Company Inc · Winchester, VAN3547GCarto Flight Inc · Willoughby, OHN3548BJaa Holdings LLC · Springfield, ILN3548JCarden Kevin · Hoover, ALN35497Fox Aircraft LLC · Bethel, AKN3549XAirplane Four LLC · Miami, FLFirst renewal noticeN3555BMtwc LLC · Ithaca, NEN3555DDove Enterprises LLC · Wilmington, DEN35580Aero Charter New England Inc · Mansfield, MAN35584Aztec Worldwide Airlines Inc · Wilmington, DEN3558XAwmr LLC · Conroe, TX
Back to AD 2016-08-18