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.
N790FEFederal Express Corporation · Memphis, TNN791DCExecutive Air Taxi Corporation · Bismarck, NDN791EBSav Aviation LLC · Jacksonville, TXN791SFFarrow Sammie N Jr · Cordele, GAN792FEFederal Express Corp · Memphis, TNN793DCBillings Clinic · Billings, MTN794FEFederal Express Corp · Memphis, TNN795FEFederal Express Corp · Memphis, TNN795LAWilmot Airplane Rentals LLC · Dover, DEN798FEFederal Express Corporation · Memphis, TNN798WCLonely Butte Management LLC · St George, UTN799ALDelt Holdings Orange LLC · Dubuque, IAN799CZN799cz LLC · Milwaukee, WIN799GKCentral Virginia Aviation Inc · North Dinwiddie, VAN79BMAgrijet Inc · Ontario, ORN79WDynamic Avlease Inc · Bridgewater, VAN7CDGillis Stratton E · League City, TXN7SASla-Flyer LLC · Steamboat Springs, CON7TPDt Connect II LLC · New York, NYN80Federal Aviation Administration · Oklahoma City, OKN8007XBaylee Company Inc · Bear, DEN800BSM&F Western Products Inc · Sulphur Springs, TXN800FRMatt Inc · Loveland, OHN800FVFolden Aviation Inc · Weiner, ARN800PGHelio Aircraft Inc · Fort Lauderdale, FLN8010GWoods Aviation LLC · Kearney, NEN8010NRoth Aerial Spraying LLC · Milford, NEN8011NH&M Flying Service LLC · Osceola, ARN8016BCoppage Farm Services Inc · Braggadocio, MOFirst renewal noticeN80176Tim Whitfield Aviation Inc · Fairfield, NCN801FFSpring Creek Aviation LLC · Brinson, GAN801FLDesert Sand Aircraft Leasing Co Inc · Rosharon, TXN801GGLone Star Land & Cattle Co · Houston, TXN801HBKansas Farm And Ranch Inc · Seneca, KSN801HFHutcherson Flying Inc · Forrest City, ARN801JASpokane Turbine Skydiving LLC · Medical Lake, WAN801RWAerial Applicators Of Missouri LLC · Qulin, MON8021PArc-170 Aviation LLC · Santa Claus, INN8024URegistered aircraftN8027QT & M Aircraft LLC · Monticello, ILN80292Kroeplin Air LLC · Highmore, SDN80293Visser Ag Inc · Rigby, IDN802AAMartinaire Aviation LLC · Addison, TXN802ACAurora Cooperative Elevator Co · Aurora, NEN802AHRanch Aero LLC · Sterling City, TXN802AJAgri Jet Inc · Aberdeen, IDN802AMFinke Aviation LLC · Charleston, MSN802APAg Air Care Inc · Wilmington, DEN802AZRiceland Aviation Inc · Jennings, LAN802BBBell Flying Inc · Newport, AR
Back to AD 2016-05-13