AD 2011-18-19
Registered aircraft · 134
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:2011-18-19')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-18-19')
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:2011-18-19') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-18-19') 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.
N320AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN320EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN322EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN323EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN324EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN327EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN328EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN329EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN32GH1 Diamond 62 LLC · Santa Fe, NMN331JSStaniforth James A · Tehachapi, CAN342NDCirrus Aviation Inc · Sarasota, FLN342TDirect Capital Holdings LLC · Colorado Springs, CON3440Western Antique Aeroplane & Automobile Museum · Hood River, ORN347DRNovember Charlie Leasing LLC · Cumming, GAN37TLPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN385LBrickyard Connection LLC · Indianapolis, INN386LLift Aircraft LLC · Carmel, INN387LLift Aircraft LLC · Carmel, INN388LLynx Connection LLC · Indianapolis, INN389LLift Aircraft LLC · Carmel, INN390LLift Aircraft LLC · Carmel, INN399SKAlf Ix LLC · Chicago, ILN408SATake Flight Aviation LLC · Montgomery, NYN411WWWuerker Christopher K · Alexandria, VAN417TSNymoon LLC · San Juan Capo, CAN421MQTake Flight Aviation LLC · Montgomery, NYN422GLSummit Aviation Inc · Belgrade, MTN424AMSkywarrior Flight Training LLC · Pensacola, FLN42KHPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN42MVVonaviation Group Vi N42mv LLC · Lewes, DEN42NGRegistered aircraftN430PSMiller Air LLC · Portland, ORN43ASSkyline Aviation Inc · San Angelo, TXN43WFAerospace Trust Management LLC · Wilmington, DEN441SAChen Aviation Inc · Princeton, NJN442ADWingsleasing LLC · Wichita, KSN442SRErdman Aviation LLC · Mather, CAN443JContrail Inc · Bethlehem, PAN44HHN44hh LLC · Tuckahoe, NYN457TSK2 Aviation LLC · Greenwood Village, CON458LLift Aircraft LLC · Carmel, INN481MRWings Level Aviation LLC · Lake Mary, FLN49AUAurora Flight Sciences · Manassas, VAN505FMSeabreeze Mc LLC · East Islip, NYN516LAGibbs John M · Monterey, CAN51AUAurora Flight Sciences · Manassas, VAFirst renewal noticeN542BLSteel Aviation Inc · Phillipsburg, OHN5566AAviation Trust Co LLC Trustee · Oklahoma City, OKN56AUAurora Flight Sciences Corp · Manassas, VAN574PADalero LLC · Lovettsville, VA
Back to AD 2011-18-19