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.
N605EAChip Aviation LLC · South Pittsburg, TNN605JDM2driver LLC · Midland, TXN605MGSims Aerial LLC · Osborne, KSN605PCLogan Health Medical Center · Kalispell, MTN605TAA + Aviation Services LLC · Goodland, KSN60662Aura LLC · Zeeland, MIN60679Shearer John · The Dalles, ORN606CMSeagull Aviation LLC · Larkspur, CAN606KAKenmore Air Harbor LLC · Kenmore, WAN606WCFlight Unlimited LLC · Smyrna, GAN60707Graden Aviation LLC · Polo, ILN60713Lewis Flying & Maintenance Service Inc · Morse, LAN6072XDakota Air Spray LLC · Huron, SDN6072YBank Of Utah Trustee · Salt Lake City, UTN6073JDukes Down Under Dusting · Ainsworth, IAN6078WDakota Air Spray LLC · Huron, SDN60792Peniston Bob · Chillicothe, MON607GKRkjm LLC · Superior, NEN607MAAllen Kelvin T Trustee · Canyon, TXN6081QPrinc Aviation LLC · Beloit, KSN6082FHouston Ag Flying Service Inc · Owensboro, KYN6082PAircraft Trustee Services Inc Trustee · Dover, DEN6082YDash Flying Service LLC · Chilton, WIN6083GAg Flyers Inc · Torrington, WYN60877Redditt Air Service Inc · Cleveland, MSN6087DTr Flying Service LLC · Milan, MNN608AGBank Of Utah Trustee · Salt Lake City, UTN6097CCrop Air LLC · Eaton, CON6099TAir Care Leasing LLC · Lamar, CON609ATAurora Cooperative Elevator Co · Aurora, NEN60CDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN60CNMewbourne Oil Company · Tyler, TXN60LTEastern Stearman Inc Trustee · Leesburg, VAN60SASandbar Air LLC · Rockwood, MEN6102UAgri Air Inc · Chamberlain, SDN6102ZGeorge'S Aerial Spraying Service Inc · Sutton, NEN6105Y4j A/C Leasing LLC · Port Saint Lucie, FLN6108LHoppe Air LLC · Beaman, IAN610GHHtc Aviation LLC · Lititz, PAN610LAT & T Capital Inc · Bangor, MEN610NASwope Cattle Inc · Anahuac, TXN610TANorth Flight Aero Med · Traverse City, MIN61175Morgenroth Dardon · Victoria, TXN611AKConverse Richard L Jr · Durango, CON611CRV J Coleman And Son · Ackerly, TXN611LAAir-Worthy Inc · Lyon, MSN611MWSky West Aviation Inc Trustee · Albuquerque, NMN61220Mike Harmon Aviation LLC · Mansfield, SDN6124GAmerican Ag Aviation Inc DBA · Five Points, CAN6124YGibson Flying Service Inc · Marianna, AR
Back to AD 2016-05-13