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.
N890FEFederal Express Corporation · Memphis, TNN891AAAugusta Aviation Inc · Augusta, GAFirst renewal noticeN891FEFederal Express Corporation · Memphis, TNN891JCAllen Chorman & Son Inc · Milton, DEN891LMn Aircraft LLC · Carolina, PRN892BABrekke Aviation Inc · Edmore, NDN892FEFederal Express Corporation · Memphis, TNN894FEFederal Express Corporation · Memphis, TNN895BMEvergreen Flying Service Inc · Dover, DEN895FEFederal Express Corp · Memphis, TNN895LAC & L Holzwarth Inc · Virden, ILN895SFNorth East Ventures C LLC · Danielson, CTN896CMXrp Investments LLC · Clyde, MIN896WPWestern Pilot Service Inc · League City, TXN897FEFederal Express Corporation · Memphis, TNN898AJNext Gen Air LLC · Colorado Springs, CON898BRElite Medical Air Transport LLC DBA · El Paso, TXN898FBFarm Brothers Flyers A LLC · Gould, ARN898SRZumwalt Aviation LLC · Sheldon, ILN899BAReliance Air LLC · Conway, ARN899FEFederal Express Corporation · Memphis, TNN89BMMilhon Air Inc · Martinsville, INN8FHIron Sky Capital LLC · Lubbock, TXN8GFVivace International Corp · San Antonio, TXN8KULange Jonathan E · Seattle, WAN8UMSkytravel Inc · Houston, TXN8YWAv Serv LLC · Dover, DEN9002KAerial Timber Applicators Inc · Cooperstown, NDN9006QCrider Flying Service · Swifton, ARN900CTRoughneck Supply LLC · Muskogee, OKN900HSBizair LLC · Wilmington, DEN900MTLincoln Ventures LLC · North Highlands, CAN900WAWright Air Service Inc · Fairbanks, AKN900ZZ110me Inc · Lake Providence, LAN901AKA C Sunni LLC · Santa Monica, CAN901BSParaclete Aviation LLC · Raeford, NCN901DMCordonnier Andrew · San Diego, CAN901STSky Team Aviation Inc · Wilmington, DEN90210Robertson Crop Dusting Service Inc · South Haven, MIN902AKDillon Aero Inc · Phoenix, AZN902DBBank Of Utah Trustee · Salt Lake City, UTN902FEFederal Express Corporation · Memphis, TNN902MCBank Of Utah Trustee · Salt Lake City, UTN90319Stevenson Flying Service Ll · Selden, KSN9032TBarts Flying Service Inc · Storm Lake, IAN9033NJohn Georg Aerial LLC · La Crosse, KSN9037NOutwest Aviation LLC · Hamilton, MTN903FEFederal Express Corporation · Memphis, TNN903JBigups Aviation 010 LLC · Valley Village, CAN903MDMaryland Department Of Agriculture · Annapolis, MD
Back to AD 2016-05-13